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...
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...
If someone read this in another forum sorry. Posted it in the wrong one.
I have a table that looks something like this.
OrderID Product Seq CustID
1 xyz 16 a494
2 fji 17 a494
3 ere 18 a494
I want to get next...
I have a table that looks something like this.
OrderID Product Seq CustID
1 xyz 16 a494
2 fji 17 a494
3 ere 18 a494
I want to get next number in Seq. I have seen something with NoCount but have no clue how to...
Can anyone tell me how to create a dynamic array in asp.
I tried all these
Dim ProductIntakeCodeArray()
Dim ProductIntakeCodeArray(RecordCount)
Dim ProductIntakeCodeArray(UBound(ProductGroupCount,2))
but only this works
Dim ProductIntakeCodeArray(17)
Problem is I dont always know what the...
I have been just recently looking at asp.net. Just learned today that we are going to have to convert all our sites to from regular asp to asp.net due to something with IIS 6.0. This a big deal and dive into asp.net or something realtively easy.
AJ
[americanflag]
Do you feel lucky?
Here is what I want to do. Click on a link and have a popup window open and have the parent window go to another page. No problem there.
The problem Im having is clicking on a link in the popup window so it closes that window and causes the parent window to go back to the original page.
That...
I am trying create a stored procedure to break a part a column and put it into 4 seperate fields.
The table looks something like this:
Route ID User Prospect Temp
-----------------------------------------
null null null null 5-W58-DJP-P
I want to it to end up...
This is an easy one. I know I did it before just cant find it. I have a column with the following data.
I-w654534-rer
2-e564654-hkh
1-e546544-dre
I want to just get the first character left of the first -.
Thanks in advance.
AJ
[americanflag]
If at first you do not succeed, cheat!
How would I map to an image on a different server. Its on an intranet so there is no problem mapping a drive or anything like that. I am using an active x viewer. The web server is already mapped to the server the image is on.
Ive tried these few ways:
E:\orders\435549996.tif...
I have two tables
A customer table
CustID FNAME LNAME Credit
1561 Jane Doe 30
5468 John Doe null
1657 John Smith null
And an Orders
CustID OrderID Orderpaid ordertotal
1561 156445 22 22
1561 156678 null null
This is the result I want to...
I have two tables.
<b>TableA</b>
CustID FName LName Credit
a12345 Joe Smith 20.00
a14568 Jane Doe Null
a56898 John Doe Null
<b>TableB</b>
OrderID CustID OrderTotal PaidTotal
15589 a12345 7.00 null
15658...
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.