Config File Help!

[menachemt]

Hello. I was wondering, can someone give me an example of what I can change this to, and how it would be read by the computer? I am trying to change this line: <TestSQL><![CDATA[SELECT COUNT(*) FROM contacts]]></TestSQL> I keep getting an error when I change it. What words do I have to keep in it? What can I change COUNT to? This is probably a silly question but I am still new to this. Thanks!

[rjgtav]

Hello. You can edit it to any SQL statement you want. You can try a simple SELECT * FROM contacts, which will return all the db's info, not only a count. You can find on the web dozens of SQL statement examples.

[menachemt]

Which one is a good example? <TestSQL>SELCET * FROM contacts</TestSQL> or <TestSQL><![CDATA[SELECT * FROM contacts]]></TestSQL>

[rjgtav]

The 2nd one. You have to enter the SQL statement inside the CDATA[]

[menachemt]

Thanks! I guess I have to check my database connection to see if its the problem. Thanks once again!