On Feb 15, 2007, at 11:20 PM, Jeffrey Ellis wrote:
Hi, Tom--
I'm not sure I'm understanding all of this. I'm getting a syntax
error on
this line:
database.SQLexecute('INSERT INTO DBServers SET Networks =
'"+Nthfield(Networks(n),EndOfLine,0)+"' A =
'"+n'"+Nthfield(Networks(n),EndOfLine,0)+ KEY_FIELD =
'"'"+Nthfield(Networks(n),EndOfLine,0)+'"+Nthfield(Networks
(n),EndOfLine,0)+
"'")
It doesn't say where, and I'm afraid I can't make heads or tails
out of
it...
database is a Class name (effectively a reserved word)
change the name of your variable to something like db as that could
be part of the problem
your quotes don't seem to match up right
database.SQLexecute('INSERT INTO DBServers SET Networks =
'"+Nthfield(Networks(n),EndOfLine,0)+"' A = '"+n'"+
the end of the previous line has '"+ when it probably should be +"'"+
Nthfield(Networks(n),EndOfLine,0)+ KEY_FIELD = '"'"+Nthfield
(Networks(n),EndOfLine,0)+'"+Nthfield(Networks(n),EndOfLine,0)+
"'")
Instead of doing all this in one line and trying to figure out where
the syntax error is pull it apart before hand and build up that
statement after than
The way you're using nthfield is likely going to give you the same
value for all columns
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
