Query needs single quote added

Repeat, due to error in my typing. By the way, I am using Token values for the entry.

Error message:

* user warning: Unknown column 'Abc' in 'field list' query:
INSERT INTO profile_values (fid,uid,value) VALUES (2,3,Abc)

Doesn't the text listed in VALUES( ) need single quotes: VALUES (2,3,'Abc') ?

It probably does need quotes. Here's how I use it on our store: http://drupal.org/node/299478. "value" there stands for the field, so no need of quotes, but if you're using a specific value, you probably do need them.

Best,
Andrey.

Hi there, Andrey. I appreciate your quick reply. I tried it with the double and single quotes and it tossed out another error. Maybe there is another process to add when using Tokens?

Entered the Operation and Default Value as a CCK text token, with the single quotes.

'[node:field_app_fname-raw]'

The quotes produced the error:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Joe\')' at line 1 query:

INSERT INTO profile_values (fid,uid,value)
VALUES (1,5,\'Joe\')

in C:\wamp\www\drupal\includes\database.mysqli.inc on line 156.

Ah, now I get what you're trying to do. You need the actual token value to be enclosed in the quotes.

Hmm... not sure about that. Maybe there's a drupal syntax for not escaping the quotes?