Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Gatorajc
  • Content: Threads
  • Order by date
  1. Gatorajc

    Text Limit for a Form Field?

    Is there a limit on how many characters that you can pass from a form? AJ [americanflag] Do you feel lucky?
  2. Gatorajc

    Passing a SP a Variable with multiple values.

    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...
  3. Gatorajc

    Calling a SP with changing Parameters

    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...
  4. Gatorajc

    Barcode Scanner throwing off Javascript

    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...
  5. Gatorajc

    Linking 3 tables

    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...
  6. Gatorajc

    Getting duplicate entries

    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?
  7. Gatorajc

    Function does not return value.

    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()...
  8. Gatorajc

    .selected

    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 =...
  9. Gatorajc

    Streaming Text

    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...
  10. Gatorajc

    Adjusting value based on even or odd number.

    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...
  11. Gatorajc

    Getting next number in sequence.

    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...
  12. Gatorajc

    Getting next number in sequence.

    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...
  13. Gatorajc

    Dynamic Array

    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...
  14. Gatorajc

    Converting ASP to ASP.NET

    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?
  15. Gatorajc

    Closing Child window and redirect of parent window.

    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...
  16. Gatorajc

    SP to Break Up Column

    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...
  17. Gatorajc

    Getting first character

    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!
  18. Gatorajc

    Mapping to an image on a different server.

    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...
  19. Gatorajc

    Getting Multiple rows from 1 table and 1 from another.

    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...
  20. Gatorajc

    Sum

    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...

Part and Inventory Search

Back
Top