Why do I get the following error code on one server
(CF4.5.1 NT4 SP5 and Access 97) but not on another -
with identical software, or on my development PC
with CF5.0? both of which work a treat?
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC Microsoft Access 97 Driver]Error in assignment (null)
Here's the query:
<cfquery datasource="allergan">
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
('#form.DBGENERE.Country#',
'#form.DBGENERE.TradeName#',
'#form.DBGENERE.InternationalName#',
'#form.Category#',
'#form.Indications#',
'#form.RegistrationNo#',
'#form.MRPReferenceNo#',
'#form.RegistrationDate#',
'#form.RenewalDueDate#',
'#form.RenewalCycle#',
'#form.RegistrationExpiry#',
'#form.SafetyReportDueDate#',
'#form.Comments#',
'#form.ProductSizeNo#',
'#form.MarketingParticulars#',
'#form.DBGENERE.FormulationNo#',
'#form.UnitDose#',
'#form.KindRegistration#',
'#form.MRPNo#',
'#form.RMSCMS#',
'#form.Rapp#',
'#form.CoRapp#')
</cfquery>
I'm baffled - any takers?
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
