Please help. I have a basic scipt:
$connection_id=odbc_connect("$DSN","$user","$pass");
$sql="select * from whatever";
$stmt=odbc_prepare($connection_id,$sql);
$result=odbc_execute($connection_id,$stmt);
this script used to work on RH-7.3 with php-4.1.2
the script will not work anymore when i ins
Have you tried with NULL instead of '' the ContactID?
On Thu, 2 Aug 2001, Steve Fitzgerald wrote:
> I keep getting the following SQL error:
>
> You have an error in your SQL syntax near ')' at line 14
>
> Line 14 is: '$FirstName', so the error must correspond to a different part
> of the code.
I keep getting the following SQL error:
You have an error in your SQL syntax near ')' at line 14
Line 14 is: '$FirstName', so the error must correspond to a different part
of the code.
Any ideas?
$add_contact_sql = "INSERT INTO $table_name
(ContactID, FirstName, LastName, Title, WorkPhone,
Hom
Which user are you connected as?
Who owns the table?
unless you connected as the user who owns the table or table is owned by dbo
you have to specify username.TBL_DEPT (where username is the name of the
user who owns the table)
At 16:47 06.07.2001 +0800, you wrote:
>[EMAIL PROTECTED]
--
PHP
hello!!!
i'm getting this error. what does this mean? hope someone can help. i'm using sql7 in
NT4 server
Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name 'TBL_DEPT'., SQL state S0002 in SQLExecDirect in F:\Web
