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!

Register Log in
  • Congratulations derfloh 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: *

  1. JamesAlex

    Adapting a function for use with repeated fields

    Hi Dan, that certainly makes sense to me - I will try adapting my code to include a loop and let you know the results! Thanks for taking the time to respond to my question so quickly. -James
  2. JamesAlex

    Adapting a function for use with repeated fields

    Hello, I'm new to JavaScript, and am have written the following function, which is run at the onClick event of a checkbox, and will populate Textfield1 with the contents of Textfield (the purpose is to allow a user to complete a single comments text box and then apply that comment to multiple...
  3. JamesAlex

    Multiple record update with parameter

    Hi all, thanks for all your help so far. I actually have the page working using an array of selected records in a similar manner to what Sheco suggested now. I have been experimenting with using session variables instead of URL parameters, and I think this looks like the best way of passing...
  4. JamesAlex

    Multiple record update with parameter

    Hello, OK, I have fixed my update statement so that it works, and have found through experimenting that my problem is actually that the page expects a URL parameter, which is referenced in the SELECT statement to return matching records. This works when first accessing the page, but on...
  5. JamesAlex

    Multiple record update with parameter

    I tried removing the rs.MoveFirst and rs.Movenext, and the page now re-loads without error on submission, but with no data (as I would expect without these commands). Unfortunately the records selected prior to submission have not been updated though! On initial access, the page displays a...
  6. JamesAlex

    Multiple record update with parameter

    Hi all, the code I am trying to use is as follows: <% if request("selected") <> "" Then rs.MoveFirst while not rs.eof ID=rs("ID") rs("Status")= DOCheck (Request("Status" & ID)) rs.update rs.Movenext wend response.redirect "Newest_Detail.asp" end if function DoCheck(fld) if fld <> "" then...
  7. JamesAlex

    Multiple record update with parameter

    Hello - please forgive the long description below... I am trying to create a web page that will allow me to update multiple database records simultaneously. I have created the pages using Dreamweaver Ultradev 4, with additional code for the multi update function. I have a search page...
  8. JamesAlex

    Using RTRIM to select first portion of a postcode

    Hi, the first query has worked perfectly for my purpose, but it is always good to know how it works - thanks for your response. -James
  9. JamesAlex

    Using RTRIM to select first portion of a postcode

    Sunil, many thanks for your swift response - your query does exactly what I need! Cheers, -James
  10. JamesAlex

    Using RTRIM to select first portion of a postcode

    Hello, I need to write a query to return the first portion of a postcode, prior to the space, from an existing table. The problem I am having is that the required string can is of variable length - either 2, 3 or 4 characters. For example the postcodes may look as follows: BU20 7DZ P16 6GS E1...

Part and Inventory Search

Back
Top