Hi. I made a data display and update asp pages using frontpage. displa

[calpolymis1]

Hi. I made a data display and update asp pages using frontpage. display.asp gets date values(MM/DD/YYYY) from MS Access database, parse an ID parameter to update.asp page. update.asp page is supposed to show the parsed ID and date values, but it only shows ID and text fields, not date fields. I think I need some formatting in the date format in between processes, but don't know how.
I also need to write/update dates to Access database after successfully displayed them, so if a new format is needed to do that, please give me an instruction.

The display.asp shows date without any problem(6/1/2006). Each text box's initial value in update.asp is set to like <%=request("ETD")%>. Thanks for your help in advance.

 

[ChrisHirst]

FormateDateTime()

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[calpolymis1]

Hi, Chris,

1. display.asp's query look like this: fp_sQry="SELECT * FROM tblDetail WHERE (CustPO = '::CustPO::') ORDER BY OrderDetailID ASC"
And it shows data like this: <%=FP_FieldVal(fp_rs,"ETD")%>

2. update.asp has a form to display data and to upload to update_records.asp.
<form method="POST" action="update_records.asp">
:
<input type="text" class="content4" name="ETD1" size="12" value="<%=request("ETD")%>"></td>

3. update_records.asp's SQL looks like this: fp_sQry="UPDATE tblDetail SET ETD='::ETD::', ETA='::ETA::' , Vessel='::Vessel::', Container='::Container::', ShipDocsCopy='::ShipDocsCopy::', ShipDocsOriginal='::ShipDocsOriginal::', MillPaid='::MillPaid::', PayReceived=':ayReceived::', DetailMemo=':etailMemo::', Destination_Detail=':estination_Detail::' WHERE OrderDetailID = ::OrderDetailID:: "

I have a problem from step 2, so I need to first make update.asp successfully displays data in date format fields, then proceed to step 3 to successfully update Access database. Where and how should I use FormatDateTime function?

 

[calpolymis1]

OK, somehow I made it show data in update.asp page in frontpage, but now when I try to update the record, I get a database error. Here's the SQL:

UPDATE tblDetail SET CustPOTrack='::CustPOTrack::', Destination_Detail=':estination_Detail::', ETD='::ETD::', ETA='::ETA::' , Vessel='::Vessel::', Container='::Container::', ShipDocsCopy='::ShipDocsCopy::', ShipDocsOriginal='::ShipDocsOriginal::', MillPaid='::MillPaid::', PayReceived=':ayReceived::', DetailMemo=':etailMemo::' WHERE OrderDetailID = ::OrderDetailID::

What could be wrong when executing this SQL?

 

[ChrisHirst]

dunno that's not SQL

post the actual query NOT the FP version of it


follow the instructions here faq333-5427 first


Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[gmmastros]

I've never seen this format before, but it looks a little inconsistent to me.

Destination_Detail=':[!][/!]estination_Detail::',

And

DetailMemo=':[!][/!]etailMemo::'



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom