Re: FN-FORUM SQL Server INSERT (easy question)

date posted 10th July 2001 13:07

Hi Peter

Just tried that and it's not working :(

Server: Msg 241, Level 16, State 1, Line 1
Syntax error converting datetime from character string.

Norman


----- Original Message -----
From: "Peter Ebdon" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Tuesday, July 10, 2001 12:35 PM
Subject: RE: FN-FORUM SQL Server INSERT (easy question)


> Norman,
>
> Try using a datetime data type for the table column instead.
>
> Cheers,
>
> Pete
>
> _________________________________________
>
> P e t e r E b d o n
> Professional Software Engineering Ltd
>
> Microsoft Certified Professional
>
> Email : [EMAIL REMOVED]
> Tel/Fax : +44(0)1235-227279
> Mobile : +44(0)7973-178945
> Web : www.pseltd.com
>
> -----Original Message-----
> From: [EMAIL REMOVED]
> [EMAIL REMOVED] Behalf Of Norman Beresford
> Sent: 10 July 2001 11:38
> To: [EMAIL REMOVED]
> Subject: Re: FN-FORUM SQL Server INSERT (easy question)
>
> Hi Carl
>
> Thanks for that, the real problem I'm having is with the time though
> I've converted the the dates as you suggested, but it's now giving me an
> error with the time. I've attached the SQL, the ASP and the error message
> at the end of this.
>
> Norman
>
> SQL
>
> INSERT INTO motivaction ( motiveTitle, motiveForename, motiveSurname,
> motiveOrganisation, motiveAddress, motivePostcode, motiveTelephone,
> motiveEmail, motiveContactMethod, motiveDate, motiveStart, motiveFinish,
> motiveVenue, motiveGuests, motivePackageID, motiveDateBooked)
> VALUES ('Miss', 'Belinda', 'Beresford', 'Private Individual', '105 Houblon
> RoadRichmondSurrey', 'TW10 6DB', '020 8241 2222,
> [EMAIL REMOVED] 'Email', 'Tuesday, September 10, 2002',
'21:00',
> '23:30', 'Back garden', 68, 11, 'Tuesday, July 10, 2001');
>
> ASP
>
> thisSQL = _
> "INSERT INTO motivaction ( motiveTitle, motiveForename, motiveSurname,
> motiveOrganisation, motiveAddress, motivePostcode, motiveTelephone,
> motiveEmail, motiveContactMethod, motiveDate, motiveStart, motiveFinish,
> motiveVenue, motiveGuests, motivePackageID, motiveDateBooked)" & _
> " VALUES ('" & bookingTitle & "', '" & bookingForename & "', '" &
> bookingSurname & "', '" & bookingOrg & "', '" & bookingAddress & "', '" &
> bookingPostCode & "', '" & bookingTelephone & "', '" & bookingEmail & "',
'"
> & bookingContactMethod & "', '" & formatdatetime(bookingDate,vbLongDate) &
> "', '" & formatdatetime(bookingTimeStart,VBShortTime) & "', '" &
> formatdatetime(bookingTimeFinish,VBShortTime) & "', '" & bookingVenue &
"',
> " & bookingNumbers & ", " & packageID & ", '" &
> formatdatetime(bookingDateBooked,vbLongDate) & "');"
>
> Error message
>
> Server: Msg 295, Level 16, State 3, Line 1
> Syntax error converting character string to smalldatetime data type.
>
>
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information please
> visit:
> http://www.freelancers.net/forum.html
>
>
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information please
visit:
> http://www.freelancers.net/forum.html
>