Are any of the form values null?......check the versions of the ODBC drivers
(in control panel) on the 2 machines - I bet there is a difference.....
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Tristram Charnley [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2001 14:26
To: CF-Talk
Subject: CFQuery insert works on one machine and not another
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
