my sql problem
Thanks for the mild rebuke paul.
I (re) created the table as follows ;-
drop table clients;
create table clients(
purchasers_ID int,
purchasers_name varchar (50),
purchase_ID int,
price decimal (7,2),
dated varchar(50)
);
I put the data away thus :-
Set objConn = Server.CreateObject("ADODB.Connection")
strConn = "Data Source= ArtSales ; User ID= ;Password= ;"
objConn.Open strConn
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.CursorLocation = adUseServer
objRS.CursorType = adOpenStatic
objRS.LockType = adLockOptimistic
objRS.Open "Orders", objConn, , , adCmdTable
obJRS.MoveLast
objRS.Update
Session("customerName") = objRS("Customer_Name")
Session("customerID") = objRS("OrderID")
objRS.close
objRS.Open "Clients", objConn, , , adCmdTable
objRS.AddNew
objRS("Purchasers_name") = Session("customerName") ****** this is
the culprit *****
objRS("purchasers_id") = Session("customerID")
ObjRS("purchase_ID") = Session("product_id")
objRS("Price") = Session("value")
objRS("dated") = now()
objRS.Update
objRS.close
%>
Anything less than 15 characters works o.k. anything more it produces
an
error.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
/Art_2/TMP287uj1ry6h.asp, line 40
Given that I have given it 50 charachters to work with I don't understand
what it can complain about. But then as I said I am very new. The other two
databases work fine using the same methods!
Thanks and regards Bob
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
