|
Azzur
Starting Member
13 Posts |
 Posted - 23 October 2003 : 10:53:01
|
Always to make to work the mod LINKs with sql comparison another problem, precisely
when I go to add a new link.. this error is underlined me:
Type of error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver][mysqld-3.23.51-nt]Column count doesn't match value count at row 1
/forum/links_add_url.asp,
Tipo di browser:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Pagina:
POST 151 bytes to /forum/links_add_url.asp
POST Data:
name=test&url=..%2Fdow%2Ftest.zip&banner=..%2Fdow%2Fimg%2Fimg.gif&des=description&key=key1%2
C+key2%2C+key3&dfile=83+KB&B1=Add&parentID=105&cat=149
the error is here in this piece of code:
if sString = "" then
strSQL = "insert into links (NAME, URL, KEYWORD, CATEGORY, DESCRIPTION, EMAIL,
BANNER_URL, POST_DATE, PARENT_ID, BADLINK, DIMENSIONE)"
strSQL = strSQL & " values"
strSql = strSQL & "('" & chkString(NAME, "SQLString") & "', '" & URL & "', '" &
chkString(KEY, "SQLString") & "', '" & cat & "', '" & chkString(DESCRIPTION, "SQLString") &
"', 0, '" & banner & "', '" & today & "', '" & parent & "', 1, 0, '" & chkString(email,
"SQLString") & "')"
my_Conn.Execute (strSQL)
but I don't understand what I am wrong!!!!! |
|
Topic Locked
