enandret
|
Posted: 05/28/2003, 1:56 AM |
|
Hy, I would like to know why the time visualized in my page is in this
format: HH.MM.SS when I have also setting the international preference and a
database time with short format (HH.MM).
Is this a problem with CodeCharge???
Why can I setting function vbShortTime in codecharge????
Thanks enzo and sorry for my english
|
|
|
DonB
|
Posted: 05/28/2003, 5:28 AM |
|
Enzo,
Did you check your "Regional Options" (in the Control Panel - it's where the
time and date formats are set for your computer)? Since you mentioned
"vbShortTime" I assume ASP is your language. The FormatDateTime function is
used by CCS, which will obey what you specify in the Regional Options. You
can select "." as the separator character.
DonB
"enandret" <enandret@libero.it> wrote in message
news:bb1tj0$tp9$1@news.codecharge.com...
> Hy, I would like to know why the time visualized in my page is in this
> format: HH.MM.SS when I have also setting the international preference and
a
> database time with short format (HH.MM).
>
> Is this a problem with CodeCharge???
>
> Why can I setting function vbShortTime in codecharge????
>
> Thanks enzo and sorry for my english
>
>
|
|
|
enandret
|
Posted: 05/28/2003, 7:26 AM |
|
I have resolved the problem by using this syntax :
fldtime=FormatDateTime(rs("d_oraInizioPianificazione"),vbShortTime)
So you can help oder users!!!
Now I have another problem:
I have three colum: IDDoctors, name, surname in a table doctors.
I would like to use a listbox to see the doctor name and surname but my
problem is that in this listbox only name or surname are disualized.
This is my code:
<td style="border-style: inset; border-width: 0"><font style="font-size:
10pt; color: #000000; font-weight: bold">Doctors</font></td>
<td style="background-color: #FFFFFF; border-width: 1"><select
name="IDDoctor"><%= get_options("select * from doctors where
IDSpecialita="&request("specialita"),false,false,IDDoctor)%></select></td>
</tr>
What can I do, if is possible???
Thanks.
Enzo
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> ha scritto nel messaggio
news:bb2a16$okc$1@news.codecharge.com...
> Enzo,
>
> Did you check your "Regional Options" (in the Control Panel - it's where
the
> time and date formats are set for your computer)? Since you mentioned
> "vbShortTime" I assume ASP is your language. The FormatDateTime function
is
> used by CCS, which will obey what you specify in the Regional Options.
You
> can select "." as the separator character.
>
> DonB
>
>
> "enandret" <enandret@libero.it> wrote in message
>news:bb1tj0$tp9$1@news.codecharge.com...
> > Hy, I would like to know why the time visualized in my page is in this
> > format: HH.MM.SS when I have also setting the international preference
and
> a
> > database time with short format (HH.MM).
> >
> > Is this a problem with CodeCharge???
> >
> > Why can I setting function vbShortTime in codecharge????
> >
> > Thanks enzo and sorry for my english
> >
> >
>
>
|
|
|
enandret
|
Posted: 05/28/2003, 9:58 AM |
|
I have just resolved.
"enandret" <enandret@libero.it> ha scritto nel messaggio
news:bb2gtn$86j$1@news.codecharge.com...
> I have resolved the problem by using this syntax :
>
> fldtime=FormatDateTime(rs("d_oraInizioPianificazione"),vbShortTime)
>
> So you can help oder users!!!
>
> Now I have another problem:
>
> I have three colum: IDDoctors, name, surname in a table doctors.
>
> I would like to use a listbox to see the doctor name and surname but my
> problem is that in this listbox only name or surname are disualized.
>
> This is my code:
>
>
> <td style="border-style: inset; border-width: 0"><font style="font-size:
> 10pt; color: #000000; font-weight: bold">Doctors</font></td>
>
> <td style="background-color: #FFFFFF; border-width: 1"><select
> name="IDDoctor"><%= get_options("select * from doctors where
> IDSpecialita="&request("specialita"),false,false,IDDoctor)%></select></td>
>
> </tr>
>
> What can I do, if is possible???
>
>
>
> Thanks.
>
> Enzo
>
> "DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> ha scritto nel messaggio
>news:bb2a16$okc$1@news.codecharge.com...
> > Enzo,
> >
> > Did you check your "Regional Options" (in the Control Panel - it's where
> the
> > time and date formats are set for your computer)? Since you mentioned
> > "vbShortTime" I assume ASP is your language. The FormatDateTime
function
> is
> > used by CCS, which will obey what you specify in the Regional Options.
> You
> > can select "." as the separator character.
> >
> > DonB
> >
> >
> > "enandret" <enandret@libero.it> wrote in message
> >news:bb1tj0$tp9$1@news.codecharge.com...
> > > Hy, I would like to know why the time visualized in my page is in this
> > > format: HH.MM.SS when I have also setting the international preference
> and
> > a
> > > database time with short format (HH.MM).
> > >
> > > Is this a problem with CodeCharge???
> > >
> > > Why can I setting function vbShortTime in codecharge????
> > >
> > > Thanks enzo and sorry for my english
> > >
> > >
> >
> >
>
>
|
|
|
DonB
|
Posted: 05/28/2003, 1:18 PM |
|
In these situations, you typically will compute a column, such as: select
IDDoctors, Firstname + Lastname AS Fullname from doctors". Then you would
bind the listbox "value" to IDDoctor and the listbox "text" to Fullname.
DonB
"enandret" <enandret@libero.it> wrote in message
news:bb2gtn$86j$1@news.codecharge.com...
> I have resolved the problem by using this syntax :
>
> fldtime=FormatDateTime(rs("d_oraInizioPianificazione"),vbShortTime)
>
> So you can help oder users!!!
>
> Now I have another problem:
>
> I have three colum: IDDoctors, name, surname in a table doctors.
>
> I would like to use a listbox to see the doctor name and surname but my
> problem is that in this listbox only name or surname are disualized.
>
> This is my code:
>
>
> <td style="border-style: inset; border-width: 0"><font style="font-size:
> 10pt; color: #000000; font-weight: bold">Doctors</font></td>
>
> <td style="background-color: #FFFFFF; border-width: 1"><select
> name="IDDoctor"><%= get_options("select * from doctors where
> IDSpecialita="&request("specialita"),false,false,IDDoctor)%></select></td>
>
> </tr>
>
> What can I do, if is possible???
>
>
>
> Thanks.
>
> Enzo
>
> "DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> ha scritto nel messaggio
>news:bb2a16$okc$1@news.codecharge.com...
> > Enzo,
> >
> > Did you check your "Regional Options" (in the Control Panel - it's where
> the
> > time and date formats are set for your computer)? Since you mentioned
> > "vbShortTime" I assume ASP is your language. The FormatDateTime
function
> is
> > used by CCS, which will obey what you specify in the Regional Options.
> You
> > can select "." as the separator character.
> >
> > DonB
> >
> >
> > "enandret" <enandret@libero.it> wrote in message
> >news:bb1tj0$tp9$1@news.codecharge.com...
> > > Hy, I would like to know why the time visualized in my page is in this
> > > format: HH.MM.SS when I have also setting the international preference
> and
> > a
> > > database time with short format (HH.MM).
> > >
> > > Is this a problem with CodeCharge???
> > >
> > > Why can I setting function vbShortTime in codecharge????
> > >
> > > Thanks enzo and sorry for my english
> > >
> > >
> >
> >
>
>
|
|
|
|