If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > Need help with asp and mysql database text field

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-03-02, 16:39
hellur hellur is offline
Registered User
 
Join Date: Nov 2002
Posts: 10
Unhappy Need help with asp and mysql database text field

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Ogiltig längd på sträng eller buffert

not in english but last thing stands
not good length on string or buffert

sql = "select * from download"
rs.open sql,dbcon,1,2
rs.addnew
rs("dUID") = session("UserID")
response.write "../mp3/" & request.querystring("path") & "/" & _
request.querystring("file")

rs("dDate") = now()
rs("dFilesize") = request.querystring("filesize")
rs("dFile") = "a" '<-- the error
rs.update
rs.close

Well the problem is that I can insert all kind of info date, time & nr but not any string in to of any kind. char, verchar or text( dFile ) in mysql
database

Need help fast start throwing things around me!
Reply With Quote
  #2 (permalink)  
Old 12-03-02, 22:03
rnealejr rnealejr is offline
Registered User
 
Join Date: Feb 2002
Posts: 2,232
What are the column names and definitions for the table download ?
Reply With Quote
  #3 (permalink)  
Old 12-04-02, 04:21
hellur hellur is offline
Registered User
 
Join Date: Nov 2002
Posts: 10
hmmm well...

database:
field:dfile type:text default: null:yes extra: key:

Connection String:
strConnect = "DRIVER={MySQL ODBC 3.51 Driver};"_
& "SERVER=localhost;" & " DATABASE=mp3;"_
& "UID=hellur;PWD=fglin; OPTION=16384"
Set dbcon = Server.CreateObject("ADODB.Connection")
Set rs=Server.CreateObject("ADODB.recordset")
dbcon.open strConnect

well this work fine becourse I can add alla other info like float, int and date but not text or char
Reply With Quote
  #4 (permalink)  
Old 12-05-02, 14:23
rnealejr rnealejr is offline
Registered User
 
Join Date: Feb 2002
Posts: 2,232
The error message you received is a broad error message - is there any more information within the event viewer when this happens or other error messages that occur at the same time. Also, be explicit in your select statement - for example, select field1, field2, field3 ... from table where ... Then reference the fields as rs(0) = ..., rs(1) = ... I would also try this with varchar and not text.
Reply With Quote
  #5 (permalink)  
Old 12-08-02, 14:16
hellur hellur is offline
Registered User
 
Join Date: Nov 2002
Posts: 10
well the fuck up thing is that if there already are a field and its have info its in 50% of the trys work ! hmm but eehahahha flöädksaöäfdlka
Fuckit hate mysql!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On