ASP Dynamic List Check If Exist

[Chad S]

Hello,

Here's a good one for you guys. I appreciate any help you can provide.

ClinShipPartNumber.asp

Currently I have this page which displays a listing of part numbers in
my database. I'm looping through the recordset and counting at the same
time and assigning the unique number to the name of the checkbox so I
can add and update within my database. All this is working great.

sSQL = SELECT * FROM tblItemMaster

<%
iCount = 0
Do While NOT rsPartListing.EOF
%>
<input type="checkbox" name="ckPartNumber<%=iCount%>"
value="<%=rsPartListing("PartNumber")%>">
<%=rsPartListing("PartNumber")%>
<%=rsPartListing("Description")%>
<%
iCount = iCount + 1
rsPartListing.MoveNext
%>

What I want to do is check and see if that particular part number is
entered into another table. If so I want to automatically check that
box, while still displaying the other possible part numbers. I'm having
difficulty comparing the two values, while still looping through both
tables.

Any thoughts ?

Thanks,
Chad

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Chris Hohmann]

"Chad S" <webaccess@hotmail.com> wrote in message
news:%23C7llI0QEHA.904@TK2MSFTNGP12.phx.gbl...

> Hello,
>
> Here's a good one for you guys. I appreciate any help you can provide.
>
> ClinShipPartNumber.asp
>
> Currently I have this page which displays a listing of part numbers in
> my database. I'm looping through the recordset and counting at the same
> time and assigning the unique number to the name of the checkbox so I
> can add and update within my database. All this is working great.
>
> sSQL = SELECT * FROM tblItemMaster
>
> <%
> iCount = 0
> Do While NOT rsPartListing.EOF
> %>
> <input type="checkbox" name="ckPartNumber<%=iCount%>"
> value="<%=rsPartListing("PartNumber")%>">
> <%=rsPartListing("PartNumber")%>
> <%=rsPartListing("Description")%>
> <%
> iCount = iCount + 1
> rsPartListing.MoveNext
> %>
>
> What I want to do is check and see if that particular part number is
> entered into another table. If so I want to automatically check that
> box, while still displaying the other possible part numbers. I'm having
> difficulty comparing the two values, while still looping through both
> tables.
>
> Any thoughts ?
>
> Thanks,
> Chad
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

Left join the tblItemMaster table to the "other" table and include an
expression in the column list of the select statement that indicates whether
the part number in the other table is null. Then when you iterate through
the recordset, output a "checked" attribute in the input tag if the
is_other_table_part_number_null field is false. You may also want to
consider using the GetRows method of the Recordset object and iterate
through the resulting array instead of iterating through the recordset.
Also, you should avoid using "SELECT *". You may even want to use some type
of stored procedure/parameterized query. Finally, when posting a database
related question, please include which database and version you are using
along with data definition language, sample data and desired output/results.
Here are some articles:

[url]http://aspfaq.com/show.asp?id=2467[/url]
[url]http://aspfaq.com/show.asp?id=2096[/url]
[url]http://aspfaq.com/show.asp?id=2201[/url]
[url]http://aspfaq.com/etiquette.asp?id=5006[/url]

HTH
-Chris Hohmann