Just in case anyone has the same probelem.
I got my answer probabaly should have posted this in the SQL Server Programming section. I just passed in the string as a varchar.
set @String = '''' + Replace('TIRES_CAPS_WHEELS','_',''',''') + ''''
Then put that in my query string.
AND...
I had previously posted a question (thread333-831424) regarding about how I would query Tires,Wheels,Caps. If I should break it up or was there something in SQL. Got a great answer
WHERE YourCriteria IN(YourCommaDelimitedListOfSelectedItems)
Well the problem I am now having is How do I get...
Not exactly a coding question more of a logic question.
I have this shipping screen. It has a select/text box that you can make multiple selections. (its one of those Javascript codes where you click a button and it moves the choice from the left box to the right). Well when it submits it...
Thanks Jeff,
Yea I have to be better about commenting first.
I fixed it. I took the alert out and went with something else.Works great now. The scanner probably has some return character at the end of its input causing the problem.
Thanks for your time.
AJ
[americanflag]
Do you feel lucky?
Im having a wierd problem that may or may not be related to Javascript. I created the following script. It is a mixture of Javascript and ASP.
The function is supposed to read a text field after the 13th character it either increments a text box or throws an alert saying the number was entered...
I have 3 tables
Orders
pk OrderID
CustId
OrderItems
pk OrderItemID
fk OrderID
fk productid
qty
Products
pk ProductId
ProductDescription
I want to get this result
CustID Qty ProductDescription
Smith 4 Meter
Thanks in advance.
AJ...
What would the query be for getting a duplicate entry.
ID DOCID DRFNAME DRLNAME
1 JSMITH Joe Smith
2 JSMITH Joe Smith
3 TJONES Thomas Jones
I just want the JSMITH's
Thanks in advance
AJ
[americanflag]
Do you feel lucky?
I have been looking at this to long. Must be something simple I am doing wrong. Can anyone tell me why this is not returning a value.
BillStatus = SetStatus()
<%
'----------------------------- FUNCTION TO SET STATUS ACCORDING TO DATE ----------------------------------
Function SetStatus()...
How would I go about getting a result like this?
document.OrderItems.ACDV_BillStatus[0].selected = true
The bold part is dynamic. I tried
document.OrderItems.products[pcnt]_BillStatus[0].selected = true;
This is what the function looks like
function ChangeStatus(formname)
{
productlist =...
Is there a new line or carriage return in ASP?
Im trying to stream some parameters to a Java Applet.
I Tried this but that is no good because it is reading the <BR> as part of the stream.
<% Response.write "[HIGHLIGHT]"%><BR>
<% Response.write "X = 824" %>
So when all is said and done. It...
I am trying to change a value based on if another variable is Even or Odd.
Mod1 = "KX"
ICD=25001 This variable changes
This is the part giving me problems. I know this would not work just showing what I want to do.
If (ICD=Odd) then
Mod1 = "KS"
End if
Much Thanks in advance.
AJ...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.