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 IamaSherpa 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: jmiller79
  • Order by date
  1. jmiller79

    Maybe a loop, Maybe not a loop. Need Help, please

    This is my whole page of events. it is called News_Events.asp. My Form is called RFQTest. <% Sub BindEvents() Set RFQTest.DataSource.CCSEvents("AfterExecuteInsert") = GetRef("RFQTest_DataSource_AfterExecuteInsert") End Sub Function RFQTest_DataSource_AfterExecuteInsert() sub...
  2. jmiller79

    Maybe a loop, Maybe not a loop. Need Help, please

    Thanks I inserted the code and got this error Microsoft VBScript compilation error '800a03ea' Syntax error /FreightCenter/RFQ/New_events.asp, line 12 sub sendmail(semail,ssubject) ^
  3. jmiller79

    Maybe a loop, Maybe not a loop. Need Help, please

    Where would I put the following code, And Thanks for all your help. "" then just loop throught the checkboxes arr=split(Request.Form("Email"),",") for i= lbound(arr) to ubound(arr) call sendmail(arr(i),request.form("filed")) next
  4. jmiller79

    Maybe a loop, Maybe not a loop. Need Help, please

    Would the check boxes only have on name because it is populated by the contact table? When I set it up I only put one check box on the page and name it email and then I populate the checkboxes by the Contact Table. This is the code(ASPMAIL) I use for AfterExecuteInsert Dim Mailer Set Mailer =...
  5. jmiller79

    Maybe a loop, Maybe not a loop. Need Help, please

    I do not know if this should go into the SQL forum instead but I will try this one first. I have a contact database in MS SQL. IT records the following data, Name, Email, Address, City, and State. There are about 50 records in this one table. There could be more but not a lot more; maybe another...
  6. jmiller79

    Email Multiple People Form Data, w/ Checkboxes

    Populated form my DB, when I hit submit on the form it show the email addresses I selected but, they are all the same url name. All say “email=jmiller@abc.com&email=rick@abc.com" How can I get them to add a number next to the label email. so like this ...
  7. jmiller79

    Email Multiple People Form Data, w/ Checkboxes

    I need a way to send the data in a form to multiple emails, by way of checkboxes, I want to have a list of people with checkboxes next to there names and if there name is check off they will receive that form data.. anyone have a way of doing this. I can send email. That is not a problem, it is...
  8. jmiller79

    Random Number

    I need to display a random 4 diget number in a Textbox field.I know javascript, but how do I put the number in the field. Thanks for any help
  9. jmiller79

    Select Stament through .ASP

    I have several reports. But now I want the user to be able to select which field to display in the report. I want the user to click on report and then a report creator displays; it will display 5-9 Drops down boxes with all the fields in the drop down available. Does anyone have a clue on how to...
  10. jmiller79

    Desktop Front End Datase help. NO MS ACCESS, any clues who to use,

    I am looking to create a desktop front end database application (NOT MS ACCESS). I also would like some info on the difference between MS SQL and Oracle Backend. I need to develop a front, what would be the best front end and what would be the backend to go with that front end. I am clueless...
  11. jmiller79

    Update Records in 1 table,Then transfer to other table. can it be done

    Thanks Guys and Gals, This has been very helpful. I gave you guys and gals all stars, have a great rest of the day
  12. jmiller79

    Update Records in 1 table,Then transfer to other table. can it be done

    I have a table called UPS. I import my flat file into the table weekly and then run the following update. UPDATE UPS SET [Invoice Number] = RIGHT([Invoice Number], LEN([Invoice Number]) - 1) This takes off the very first 0 in every record. My issue is when I import more data into the table and...
  13. jmiller79

    stored procedure, trigger, update query.NOT SURE.

    I get this error in SQL "Warning: The table 'UPS' has been created but its maximum row size (16227) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes. Server: Msg 242, Level 16, State 3, Line 1...
  14. jmiller79

    stored procedure, trigger, update query.NOT SURE.

    Thanks, I gave you a tipmaster Star, I have one more question. In this flat file i receive. I get a date field. But it come in like this 02052005. When I import this into my SQL database, it imports as text. When I import it into Excel, it imports text, When I try to convert it, it does not...
  15. jmiller79

    stored procedure, trigger, update query.NOT SURE.

    I need to run either a stored procedure, trigger, update query. I am not sure, maybe some can help me, I have a flat file I import into my database. I have a field called [Invoice Number]. This field contains both alpha, numeric values (Ex. 000001754HRE0), what I am trying to accomplish is...
  16. jmiller79

    Drop a Zero form the invoice Number

    Not working, I try to do n update query but no luck, The invoice number has letters and numbers, is that why, Any help would be great , thanks
  17. jmiller79

    Drop n Zero form the invoice Number

    I need it from 000074 to 00074. The first value in the invoice will always be a number, I just need to drop the first 0 form the invoice, it will always be a zero THANKS
  18. jmiller79

    Drop a Zero form the invoice Number

    I get a flat file form a customer, I import the file into a MS Access table, but somehow i need to drop the first zero form the invoice number, any help would be great
  19. jmiller79

    Drop n Zero form the invoice Number

    I get a flat file form a customer, I import the file into a MS Access table, but somehow i need to drop the first zero form the invoice number, any help would be great THANKS
  20. jmiller79

    CSS Help, Confused on using # instead of .

    I am brand new to CSS and I am very confused, maybe someone can help me. I bought a book to help, and I noticed that inside of the HTML <style> tag you use the “div#” and sometime you use “div.”. What is the difference, and when do you use one appose top the other. For example Example 1 <style>...

Part and Inventory Search

Back
Top