SQL statement problems

	Home Register Search Help Login

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sponsors
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

SQL statement problems

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> SQL statement problems

Page: [1]


friedsock Posts: 1 Joined: 10/10/2009 Status: offline	SQL statement problems - 10/10/2009 8:31:35 I am getting this error message from a cgi script: Execution problem: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. (SQL-07002) I am really confused by this. I have double-checked the sql statement but I keep returning 0 parameters. Here is the code( I am using perl dbi): my $DSN = 'driver=Microsoft Access Driver (*.mdb);dbq=d:\domains\pet-tortoise.co.uk\wwwroot\testingdatabase.mdb'; my $dbh = DBI->connect("dbi:ODBC:$DSN", '','') or die "$DBI::errstr\n"; my $sql = <<"ENDOFSQL"; INSERT INTO Table2 (Firstname,Surname) VALUES ($FORM{firstname},$FORM{surname}) ENDOFSQL $dbh->do($sql) or die "Execution problem: $DBI::errstr"; thanks.