| Author |
 Topic  |
|
DarkDrift
Junior Member
USA
126 Posts |
 Posted - 29 December 2004 : 19:52:21
|
I don't quite understand:
INSERT INTO forum_topics ([CAT_ID],[FORUM_ID],[T_STATUS],[T_MAIL],[T_SUBJECT],[T_MESSAGE],[T_AUTHOR],[T_REPLIES],[T_UREPLIES],[T_VIEW_COUNT],[T_LAST_POST],[T_DATE],[T_LAST_POSTER],[T_IP],[T_LAST_POST_AUTHOR],[T_LAST_POST_REPLY_ID],[T_ARCHIVE_FLAG],[T_LAST_EDIT],[T_LAST_EDITBY],[T_STICKY],[State],[City],[User],[link],[WEBLINK],[STARS]) VALUES('1','1',1,0,'tes12421','joppatowne, darkdrift','1','0, 1','0','0','2004','2004','0','000.000.000.000','1','0','1',' ',' ',0,'1','1',' ','null','www.jottswebhosting.com','0')
[CAT_ID] is 1
[FORUM_ID] is 1
[T_STATUS] is 1
[T_MAIL] is 0
[T_SUBJECT] is TEXT
[T_MESSAGE] is TEXT
[T_AUTHOR] is TEXT
[T_REPLIES] is 0
[T_UREPLIES] is 0
[T_VIEW_COUNT] is 0
[T_LAST_POST] is 0
[T_LAST_POSTER] is 0
[T_IP] is 000.000.000.000
[T_LAST_POST_AUTHOR] is 0
[T_LAST_POST_REPLY_ID] is 0
[T_ARCHIVE_FLAG] is 0
[T_LAST_EDIT] is 2004
[T_LAST_EDITBY] is 0
[T_STICKY] is 0
[State] is 1
[City] is 1
[User] is DarkDrift
[link] is --nothing--
[WEBLINK] is http://www.google.com
[STARS] is 0)
Everything has a value either from the Shown forms or the hidden ones?
let me know...thanx |
http://www.xcalliber.com - The Future of Boards |
 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 29 December 2004 : 23:55:02
|
You should do the slow but sure debugging.
Start with one or two columns in your sql. Verify it works. Then add a column and value pair for the next column, verify it works. Add another column & value pair, ...
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 30 December 2004 : 12:34:18
|
I'm sorry. It's T_LAST_EDIT, T_LAST_EDITBY and USER that are empty.
Source from your demo
<input type="hidden" value="" name="TLASTEDIT" size="20">
<input type="hidden" value="" name="TLASTEDITBY" size="20">
I couldn't find a USER input.
Dougs right. You should start with just a few and work your way to the end. Then you will know which one is causeing the error. |
_-/Cripto9t\-_ |
|
|
|
DarkDrift
Junior Member
USA
126 Posts |
|
|
Topic |
|
|
|
Topic Locked
