SQL Database Integration

Re: Check if a value already exist

Matt Faus — Mon, 12 Dec 2005 20:55:11 GMT

Make sure your XPath is right. Also, if you get an object expected error, maybe that means that there were no rows that matched your criteria in the database, which tells you what you need to know.

What exactly is your error and could you give us the code snippet that is performing your query?

---------------
Matt Faus
InfoPath Dev Texas

Re: Check if a value already exist

bslaght — Mon, 12 Dec 2005 20:13:42 GMT

I am not having much luck here, getting a debug error, says object expected. Thoughts?

Re: Check if a value already exist

Matt Faus — Fri, 09 Dec 2005 20:24:24 GMT

Just ask the database if it has one already in there:

var query = "SELECT id from mytable where id=" + XDocument.DOM.selectSingleNode( "//my:id" ).text;

If it returns a row, then you know there is already an ID of that value in the database, if it doesn't you're in luck!

Hope this helps!

---------------
Matt Faus

Check if a value already exist

bslaght — Fri, 09 Dec 2005 19:46:54 GMT

My form hits an SQL database, I want to check to see if a value entered into a text box already exist in the database.

Basically I want to make sure that the number (Member ID) is unique within the database.

Any Ideas?