Format database field

10/09/2003 - 04:01 por Portugalmidi | Informe spam
Hi
i'm a newbie on this so be patient with me
I have a database connection made by frontpage and it's working

One of the lines show a field called data that haves a date content as show
below

<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Data,Local,Nome_do_computador_remoto,Nome_de_utilizador,Ti
po_de_browser,Carimbo_de_data/hora" s-column="Data" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Data&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Data")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="3259" --></td>

I woul like to have thist code showing only month or year or day
something like as i do in vb executing day(datefield) or year(yearfield)

i would appreciate any help
thank you
 

Leer las respuestas

#1 news.microsoft.com
10/09/2003 - 09:07 | Informe spam
Already try to change the code

<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Data,Local,Nome_do_computador_remoto,Nome_de_utilizador,Ti
po_de_browser,Carimbo_de_data/hora" s-column="Data" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Data&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=day(FP_FieldVal(fp_rs,"Data"))%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="3259" --></td>

but when i try to save frontpage changes are not saved getting a message in
portuguese
"O conteúdo de um componente do Frontpage foi modificado. Esse conteúdo será
substituído qundo guardar esta página."

Again any help is welcome

"Portugalmidi" escreveu na mensagem
news:3f5e8e08$0$192$
Hi
i'm a newbie on this so be patient with me
I have a database connection made by frontpage and it's working

One of the lines show a field called data that haves a date content as


show
below

<!--webbot bot="DatabaseResultColumn"



s-columnnames="ID,Data,Local,Nome_do_computador_remoto,Nome_de_utilizador,Ti
po_de_browser,Carimbo_de_data/hora" s-column="Data" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Data&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Data")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="3259" --></td>

I woul like to have thist code showing only month or year or day
something like as i do in vb executing day(datefield) or year(yearfield)

i would appreciate any help
thank you



Preguntas similares