Últimos mensajes - Powered by IBM

Palabras claves

format database field

09/09/2003 - 02:57 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

<%=FP_FieldVal(fp_rs,"Data")%></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

Siga el debate

5 respuestas

Tengo una respuesta

Preguntas similare

Format database field

Leer las respuestas

#1 Jhonny Vargas P.

11/09/2003 - 15:29 | Informe spam

you watch the following Function that makes the that you need...

Year(Date)
Month(Date)
Day(Date)

you pardon my English

Saludos,
Jhonny Vargas P. [MS MVP-ASP]
Santiago de Chile

"Portugalmidi" wrote in message
news:3f5d2577$0$190$

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;&lt;Data&gt;&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Data")%></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

Responder a este mensaje

#2 news.microsoft.com

11/09/2003 - 20:24 | Informe spam

thank you
i changed the code from

s-columnnames="ID,Data,Local,Nome_do_computador_remoto,Nome_de_utilizador,
Tipo_de_browser,Carimbo_de_data/hora" s-column="Data" b-tableformat="TRUE"
b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;&lt;Data&gt;&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Data")%></td>

to

<%=day(FP_FieldVal(fp_rs,"Data"))%>

and it's working. The only thing i don't know is what does the rest of the
code.
Maybe someday ... :-)

Thank you again

Ps: I understand spanish but i can´t write it (portuguese people, you know)

"Jhonny Vargas P." escreveu na mensagem
news:

you watch the following Function that makes the that you need...

Year(Date)
Month(Date)
Day(Date)

you pardon my English

Saludos,
Jhonny Vargas P. [MS MVP-ASP]
Santiago de Chile

"Portugalmidi" wrote in message
news:3f5d2577$0$190$
> 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=" size="-1">&lt;&lt;Data size="-1">&gt;&gt;"
> startspan --><%=FP_FieldVal(fp_rs,"Data")%></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
>
>
>

Responder a este mensaje

#3 Jhonny Vargas P.

11/09/2003 - 20:56 | Informe spam

What database you are using?

If you are using Sql Server 7.0 or 2000, you can occupy the function
Convert() Or Cast() for format the date as you consider (mm/dd/yyyy or
yyyy/mm/dd or etc...)

therefore, don't necessary use format in the Page ASP, it's to say, you
format the Date in the query...

You tell me, that database you use

Saludos,
Jhonny Vargas P. [MS MVP-ASP]
Santiago de Chile

"news.microsoft.com" wrote in message
news:#

thank you
i changed the code from

s-columnnames="ID,Data,Local,Nome_do_computador_remoto,Nome_de_utilizador,
Tipo_de_browser,Carimbo_de_data/hora" s-column="Data" b-tableformat="TRUE"
b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;&lt;Data&gt;&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Data")%></td>

to

<%=day(FP_FieldVal(fp_rs,"Data"))%>

and it's working. The only thing i don't know is what does the rest of the
code.
Maybe someday ... :-)

Thank you again

Ps: I understand spanish but i can´t write it (portuguese people, you

know)

"Jhonny Vargas P." escreveu na mensagem
news:
>
> you watch the following Function that makes the that you need...
>
> Year(Date)
> Month(Date)
> Day(Date)
>
> you pardon my English
>
> Saludos,
> Jhonny Vargas P. [MS MVP-ASP]
> Santiago de Chile
>
>
>
>
> "Portugalmidi" wrote in message
> news:3f5d2577$0$190$
> > 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=" > size="-1">&lt;&lt;Data > size="-1">&gt;&gt;"
> > startspan --><%=FP_FieldVal(fp_rs,"Data")%></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
> >
> >
> >
>
>

Responder a este mensaje

#4 news.microsoft.com

11/09/2003 - 21:23 | Informe spam

i'm using a acess 2002 database created with frontpage

"Jhonny Vargas P." escreveu na mensagem
news:

What database you are using?

If you are using Sql Server 7.0 or 2000, you can occupy the function
Convert() Or Cast() for format the date as you consider (mm/dd/yyyy or
yyyy/mm/dd or etc...)

therefore, don't necessary use format in the Page ASP, it's to say, you
format the Date in the query...

You tell me, that database you use

Saludos,
Jhonny Vargas P. [MS MVP-ASP]
Santiago de Chile

"news.microsoft.com" wrote in message
news:#
> thank you
> i changed the code from
>
>

s-columnnames="ID,Data,Local,Nome_do_computador_remoto,Nome_de_utilizador,

> Tipo_de_browser,Carimbo_de_data/hora" s-column="Data"

b-tableformat="TRUE"

> b-hashtml="FALSE"
> b-makelink="FALSE" clientside b-MenuFormat preview=" size="-1">&lt;&lt;Data size="-1">&gt;&gt;"
> startspan --><%=FP_FieldVal(fp_rs,"Data")%></td>
>
> to
>
> <%=day(FP_FieldVal(fp_rs,"Data"))%>
>
> and it's working. The only thing i don't know is what does the rest of

the

> code.
> Maybe someday ... :-)
>
> Thank you again
>
> Ps: I understand spanish but i can´t write it (portuguese people, you
know)
>
> "Jhonny Vargas P." escreveu na

mensagem

> news:
> >
> > you watch the following Function that makes the that you need...
> >
> > Year(Date)
> > Month(Date)
> > Day(Date)
> >
> > you pardon my English
> >
> > Saludos,
> > Jhonny Vargas P. [MS MVP-ASP]
> > Santiago de Chile
> >
> >
> >
> >
> > "Portugalmidi" wrote in message
> > news:3f5d2577$0$190$
> > > 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

> > 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=" > > size="-1">&lt;&lt;Data > > size="-1">&gt;&gt;"
> > > startspan --><%=FP_FieldVal(fp_rs,"Data")%></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
> > >
> > >
> > >
> >
> >
>
>

Responder a este mensaje

#5 Jhonny Vargas P.

11/09/2003 - 21:39 | Informe spam

ok, the solution was for the Sql Server and not for Access...

But, go to problem...

i don't know of where you have the function "FP_FieldVal" ?

What code had it's function?

i don't know as it uses frontpage... sorry.

Saludos,
Jhonny Vargas P. [MS MVP-ASP]
Santiago de Chile

"news.microsoft.com" wrote in message
news:#

i'm using a acess 2002 database created with frontpage

"Jhonny Vargas P." escreveu na mensagem
news:
> What database you are using?
>
> If you are using Sql Server 7.0 or 2000, you can occupy the function
> Convert() Or Cast() for format the date as you consider (mm/dd/yyyy or
> yyyy/mm/dd or etc...)
>
> therefore, don't necessary use format in the Page ASP, it's to say, you
> format the Date in the query...
>
> You tell me, that database you use
>
>
> Saludos,
> Jhonny Vargas P. [MS MVP-ASP]
> Santiago de Chile
>
>
>
>
> "news.microsoft.com" wrote in message
> news:#
> > thank you
> > i changed the code from
> >
> >
s-columnnames="ID,Data,Local,Nome_do_computador_remoto,Nome_de_utilizador,
> > Tipo_de_browser,Carimbo_de_data/hora" s-column="Data"
b-tableformat="TRUE"
> > b-hashtml="FALSE"
> > b-makelink="FALSE" clientside b-MenuFormat preview=" > size="-1">&lt;&lt;Data > size="-1">&gt;&gt;"
> > startspan --><%=FP_FieldVal(fp_rs,"Data")%></td>
> >
> > to
> >
> > <%=day(FP_FieldVal(fp_rs,"Data"))%>
> >
> > and it's working. The only thing i don't know is what does the rest of
the
> > code.
> > Maybe someday ... :-)
> >
> > Thank you again
> >
> > Ps: I understand spanish but i can´t write it (portuguese people, you
> know)
> >
> > "Jhonny Vargas P." escreveu na
mensagem
> > news:
> > >
> > > you watch the following Function that makes the that you need...
> > >
> > > Year(Date)
> > > Month(Date)
> > > Day(Date)
> > >
> > > you pardon my English
> > >
> > > Saludos,
> > > Jhonny Vargas P. [MS MVP-ASP]
> > > Santiago de Chile
> > >
> > >
> > >
> > >
> > > "Portugalmidi" wrote in message
> > > news:3f5d2577$0$190$
> > > > 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=" > > > size="-1">&lt;&lt;Data > > > size="-1">&gt;&gt;"
> > > > startspan --><%=FP_FieldVal(fp_rs,"Data")%></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
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Siga el debate Respuesta

Responder a este mensaje

Ads by Google

Hacer una pregunta

Tengo una respuesta

Busqueda sugerida