Search results for query: *

I see what you are saying I just don't know how to do it. Does this statement need to be changed or something else? rsCon.Open "SELECT * FROM Serviced_Equipment WHERE cusID = " & Request("company"), db, 3, 3, 1

Thanks, I have a couple more issues. One is if you happen to go back and select the option "Choose..." after you've selected a database item it throws this error: Microsoft JET Database Engine error '80040e14' Syntax error in query expression 'cusID = Choose . . .'...

I have a drop down list that is being populated by a database, and it is throwing an 800a000d Type Mismatch error. Here is the line of code the error occurs on: <option value="<%=rsCus("cusID")%>" <%if CInt(rsCus("cusID")) = CInt(d) then%> selected<%end if%>><%=rsCus("Company")%></option>...

Sounds like a splendid idea, only I'm not quite sure what you are talking about. I'm not familiar with that process. Do you have any details on how that would be accomplished?

I have several elements of each record I want to send ie: part #, price, quantity, etc. How can they all be tied to the checkbox that way? Here is the code: <table width="100%" border="0" cellpadding="3" cellspacing="0" style="FONT-SIZE: 9pt"> <% Set rsPrt =...

Ok, I've got the info displaying as needed. Now, I've come to another bump in the road. I have the page displaying the results with a checkbox. The idea is to have the user select the needed parts and then submit them which in turn displays on a new page the selected parts to be printed. How do...

I've kind of bare bonesed it and started over. I have no idea if what I've got now is close to working but I'm getting this error: Microsoft VBScript compilation error '800a03fb' Expected 'Loop' /modules/parts/OrderParts.asp, line 49 And here is the code as it stands now: <% set...

I'm now getting this error: Microsoft VBScript compilation error '800a0400' Expected statement /modules/parts/prtFunctions.asp, line 1482 END SELECT ^ with this code: <% rsPrt.Open "SELECT * FROM Parts WHERE parVendor = ' AND qtyonHand <= reorderLevel AND recStock >= 1" &...

I'm not sure what is essential and what is not in the asp code. Right it displays that no parts need reordering which is incorrect. So, its backwards. This is what I currently have: <table width="100%" cellspacing="0" cellpadding="3" border="0" style="FONT-SIZE: 9pt"> <% Set rsVen =...

I'm having issues connecting with the server but does this look right? <% rsPrt.Open "SELECT * FROM Parts WHERE parVendor = ' AND qtyonHand <= reorderLevel AND recStock > 0" & rsVen("Company") & "'", db, 3, 3, 1 then%>

I thought about it, but I haven't actually tried. Let me give it a whirl and see what happens. Thanks.

I'm working on this app that displays parts that need to be reordered. I need it not to show parts that have their recommended stock at zero, and I have yet to figure out the best way to do it. Any help is greatly appreciated. Here's the code: % Set rsVen =...