I'm not using any Cache COMs, Factory or anything like that. So I just add
the To_Date into the SQL statement that is passed to the ODBC connection?
I'm using only ASP.NET and ODBC for coding, no imports other than the ODBC
used by ASP.NET. I tried to do it inline like your example and I get this
when I use the date 2/15/1981:
ERROR [HY000] [Cach� ODBC][State : S1000][Native Code 105]
[C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_wp.exe] [SQLCODE:
<-105>:<Field validation failed in UPDATE>] [Details: <FLoop - func = DU>]
[%msg: <Field 'DOB' (value '18 May 1846') failed validation>]
Here is my code:
FinDate = MyDate.ToString("yyyy-MM-dd")
Dim mystring As String = "Update Nothing.Customer set dob = To_Date(" &
FinDate & "), Name = '" & HName.Text & "', HomeAdd_Street = '" & haddr.text
& "', HomeAdd_City = '" & hcity.Text & "', HomeAdd_State = '" & hstate.text
& "', HomeAdd_Zip = '" & hzip.text & "', HomePhone= '" & hphone.text & "',
Email= '" & hemail.text & "' where Name = '" & MyList.SelectedValue & "'"
"Steve Sutton" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi Clay
> With my application I do quite a bit of SQL through ODBC.
> Dates are more cumbersome than other data types, including TimeStamp
(which
> you can treat as a string).
>
> I've had good success using the SQL Function To_Date() that Cach�
provides.
> It allows you to pass a formatting string, but I often use the default
> format for simplicity.
>
> Example for Table OrderHeader, Field ShipDate, if I want to change the
> ShipDate to 1 May where the ShipDate is currently 1 Jan:
>
> UPDATE OrderHeader
> SET ShipDate = To_Date('01 MAY 2004')
> WHERE ShipDate = To_Date('01 JAN 2004')
>
>
> It's listed in the SQL docs. I keep the main page as one of my favorites.
> You can find it at:
> http://127.0.0.1:1972/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL
>
> if you're not running Cach� on your local machine, replace 127.0.0.1 with
> the IP address of your server
>
> Also, if you ever get back a "date serial" number when using To_Date, you
> can nest it inside another To_Date, and it will usually return a formatted
> string.
>
> Good Luck
> Steve
>
> "Clay Black" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > I just completed the Cache Beginners training course and was using
ASP.NET
> > to test UPDATE, INSERT, and DELETE commands on Cache. I am using
> > Dreamweaver as my web development app and I am straight coding it, not
> using
> > any wizards,etc. I need to save/update a DOB field, but when I do it is
> set
> > in 1842 or something like that. I understand that $zdh will convert it
to
> a
> > "friendly" date but how do I do that via ODBC? I thought that it would
be
> > automatic through the Cache Supplied ODBC connector, but it isn't. I do
> not
> > use Cache Factory, just straight ASP coding and ODBC.
> >
> > Any help would be greatly appreciated.
> >
> >
>
>
