Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: How to insert more than one column into Access database table?

by Rich36 (Chaplain)
on Oct 08, 2002 at 21:30 UTC ( #203762=note: print w/replies, xml ) Need Help??


in reply to How to insert more than one column into Access database table?

It might help to specify the column names in the INSERT query. If you have more columns than the number of values you are inserting, that can cause problems. Try this and specify your column names.

$sqlinsert ="INSERT INTO T_table (Column1, Column2, Column3) VALUES($I +D,$Folder, $Webpage)";

This page contains some good SQL references.

«Rich36»
  • Comment on Re: How to insert more than one column into Access database table?
  • Download Code

Replies are listed 'Best First'.
Thanks a lot, Rich36
by Yelenna2003 (Initiate) on Oct 17, 2002 at 01:27 UTC
    Thanks a lot, Rich36. Yelenna2003

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://203762]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (5)
As of 2021-04-13 07:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?