No, the query runs fine on my machine (CF5 W98 and Access) and
on our development server (CF4.5.0 NT4SP5 SQL Server7)
but not on our production server with CF4.5.1
Here's the query anyway:
<cfquery datasource="#application.ds#">
INSERT INTO DBGENERE (Country,
TradeName,
InternationalName,
Category,
Indications,
RegistrationNo,
MRPReferenceNo,
RegistrationDate,
RenewalDueDate,
RenewalCycle,
RegistrationExpiry,
SafetyReportDueDate,
Comments,
ProductSizeNo,
MarketingParticulars,
FormulationNo,
UnitDose,
KindRegistration,
MRPNo,
RMSCMS,
Rapp,
CoRapp)
VALUES ('#Attributes.DBGENERE.Country#',
'#Attributes.DBGENERE.TradeName#',
'#Attributes.DBGENERE.InternationalName#',
'#Attributes.Category#',
'#Attributes.Indications#',
'#Attributes.RegistrationNo#',
'#Attributes.MRPReferenceNo#',
'#Attributes.RegistrationDate#',
'#Attributes.RenewalDueDate#',
'#Attributes.RenewalCycle#',
'#Attributes.RegistrationExpiry#',
'#Attributes.SafetyReportDueDate#',
'#Attributes.Comments#',
'#Attributes.ProductSizeNo#',
'#Attributes.MarketingParticulars#',
'#Attributes.DBGENERE.FormulationNo#',
'#Attributes.UnitDose#',
'#Attributes.KindRegistration#',
'#Attributes.MRPNo#',
'#Attributes.RMSCMS#',
'#Attributes.Rapp#',
'#Attributes.CoRapp#')
</cfquery>
> -----Original Message-----
> From: Pete Freitag [mailto:[EMAIL PROTECTED]]
> Sent: 26 September 2001 17:27
> To: CF-Talk
> Subject: RE: ODBC error code
>
>
> Are you using any reserved words? send your query.
>
> +++++++++++++++++++++++++++++++++++++++
> Pete Freitag ([EMAIL PROTECTED])
> CFDEV.COM
> ColdFusion Developer Resources
> http://www.cfdev.com/
>
>
> -----Original Message-----
> From: Tristram Charnley [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 26, 2001 12:12 PM
> To: CF-Talk
> Subject: ODBC error code
>
>
> Does anyone knows what this signifies?
>
> ODBC Error Code = 22005 (Error in assignment)
>
> (MS Access)
>
> Tristram Charnley
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
