[Asterisk-Users] using the MYSQL command to insert a record

[Robert Howard]

I am trying to use the MYSQL command to insert a
record into a database and I can't seem to get it to
work. I can do an UPDATE with no problem.
Here is the line in my dialplan
exten => s,12,MYSQL(QUERY resultid ${connid} INSERT
INTO `member` ( `id` , `member_num` , `active` )VALUES
('',${number}' , '1'))

Does anyone have an example of an INSERT INTO that I
could look at?

Thanks 
Robert Howard


		
__________________________________ 
Do you Yahoo!? 
The all-new My Yahoo! - Get yours free! 
http://my.yahoo.com