At 20:56 +0100 9/1/02, Bob G wrote:
>my sql problem
>
>Thanks for the mild rebuke paul.
Not a rebuke, really. It's just that people cannot help you without
information.
>
>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)
>);
Looks okay. Below you show a program for inserting records into the
table. What happens if you use the mysql program from the command line
to insert records into the table that have values longer than 15 characters?
Does it work? If so, then the the problem will be due to something about
your program.
>
>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!
You mean you have 50-char columns in those databases and you can insert
more than 15 characters into them?
>
>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
