Hello,

What does this error mean?

ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] 
Duplicate output destination 'Partnumbertwo'.
SQL = "UPDATE purchases 

Here is some of the code:

SQL = "UPDATE purchases 
SET Vendor = 'CDW Warehouse',
        Invoicenumber = '989MMPQhhhhh',
        Contact = 'John Q. Public',
        Address = 'Main street',
        address2 = '',
        City = 'Jackson',
        State = 'KY',
        Zip = '20020',
        Country = '',
        Phone = '888888',
        Qtytwo = 0.0,
        Descriptiontwo = '',
        Partnumbertwo = '',
        Costeachtwo = 0.0,
        Totaltwo = 0.0,
        Comments = ''
Where ID = 1710"<P>Data Source = "PURCHASES"<P><p>The error occurred while processing 
an element with a general identifier of (CFQUERY), occupying document position (4:1) 
to (4:46) in the template file d:\InetPub\wwwroot\Adeleforms\getpurchaseorder2a.cfm

Thanks ahead for the help/advice.

Robert O.
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.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

Reply via email to