I am trying to substring the insert of the reply field as per below and keep getting an error. I know the ODBC insert replaces the quotes in some manner, but cannot get the below query to work. Can ypou please let me know what I am doing wrong?
Insert into UserCapacity (Eventtime,Folder,Reply) Values (Getdate(),'%Folder%','Substring(%Reply%,CharIndex('Participants=',%Reply%)+13,Charindex('|Conferences=',%Reply%)-charindex('Participants=',%Reply%)-13)')
When Using the following query
Insert into HMCapacity (Eventtime,Folder,Reply) Values (Getdate(),'%Folder%','%Reply%')
Here are results
ACK|Command=ConfCount|MessageNumber=0|Participants=0|Conferences=0|Returned=Success|\r\n\r\n
SQL Query Action Syntax Error
SQL Query Action Syntax Error
Last edited by RRing on Thu Feb 25, 2010 11:30 am, edited 1 time in total.
SQL Query Action Syntax Error
Thanks Alex- I missed that. Looks like I had that wrong, and also had to remove the quotes around the complete substring command. All works good now. Thanks you for your quick reply.