VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Customization
 Can''t Add states
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jinesh
VP-ASP New User

141 Posts

Posted - July 04 2008 :  03:00:00  Show Profile  Reply with Quote
When i try to add states, the following error was the result

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/shopa_editrecord.asp, line 302
Do anyone know y it shows so?


Jinesh

madbug
VP-ASP New User

130 Posts

Posted - August 01 2008 :  06:20:03  Show Profile  Reply with Quote
the database connection strings do not handle the two update queries.
Just change the code in shopa_editrecord.asp

find the code:

Sub GenerateUpdateSQL()
Dim howmanyfields
dim fieldname, fieldvalue, fieldtype
dim i, typename
howmanyfields=rstemp.fields.count -1
rstemp.update

and commet the last line out, become

'rstemp.update
Go to Top of Page

pokara
Starting Member

Spain
6 Posts

Posted - October 02 2008 :  09:13:52  Show Profile  Reply with Quote
Sorry my english..

Ive got the same problem trying to add a new state...
I have try about the commet the last line out, but then ive got this error:

ADODB.Recordset error '800a0c93'
Operation is not allowed in this context.
/nacho/tiendavm/shopa_editrecord.asp, line 267

Any idea??

Cause when i try to add a new state then ive got the message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

And it creates a record empty..
I have to edit this empty record, and then i can write the state and its working in that way.. ?

It looks that let me update the record, but i cant add a new one... This is my problem..

Cause i have to write all the states for spain (provinces, like Madrid,Barcelona,Sevilla,...etc)

Thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000