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 strongm 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: jcj88
  • Order by date
  1. jcj88

    client regional settings...

    I don't believe there is a way to do this through ASP (it would be a gross security violation if you could). You can determine some information about the client browser, but not too much about the client system (just OS and version, I think). Same thing in client-side JavaScript. Couldn't you...
  2. jcj88

    Changing fields

    If you are doing it in Access, why not use the access front end? Create a new table that you want your old table to look like, then copy the data in. Then rename and viola.
  3. jcj88

    Strange Situation re: Retrieval & Display of Records

    On this line, you could possibly over-step the array bounds b/c of the i+1 and i+2 in the arrays: output = Arrnames(1,i) & vbtab & Arrnames(1,i+1) & vbtab & Arrnames(1,i+2) You probably need to check if i+1 and i+2 are over the UBOUND (something like this): If i+1 > ubound(arrnames,2) OR i+2...
  4. jcj88

    Strange Situation re: Retrieval & Display of Records

    oops, meant: output = Arrnames(0,i) NOT output = Arrnames(1,i) ...For the Name column.
  5. jcj88

    Strange Situation re: Retrieval & Display of Records

    Sorry for the confusion, it should be: output = Arrnames(0,i) NOT output = Arrnames(0,i) Basically, just subtract one from the first column in the array. But now I noticed another error, you need to check that you are not above the UBOUND before referencing i+1 and i+2. For example, lets...
  6. jcj88

    Strange Situation re: Retrieval & Display of Records

    In VB Script, arrays are always zero-based. So 0=Name, not 1. Also, speaking as a DBA, don't use Select *, use the actual column names. Otherwise you may get unnecessary pseudo-columns (depending on the rdbms) or cause the database to take an inefficient path to the data.
  7. jcj88

    Strange Situation re: Retrieval & Display of Records

    Thanks for the info on activePDF. For your code, you need to check the boolean variable before doing the loop (you will get an error otherwise): If booData Then ... End If Also, in the array you need to reference a number and not the actual name of the column. For instance, 0 = name, 1 =...
  8. jcj88

    Strange Situation re: Retrieval & Display of Records

    The 1 and 2 in the array are the database columns. When you use GetRows, it dims the first dimension to 0 to n-1 fields pulled from the database. The second dimension is the row number (0 to m-1 rows). So in her example above, Arrnames(1,i) is the "Address1" column from the i-th row...
  9. jcj88

    show a different random record each click next

    You'd probably need to store which records your users have seen. Maybe store the pk of the records in a session var or cookie (depending on persistence), then use a NOT IN in your SQL statement with these primary keys. Do the users login to your site? If so, maybe store the info in the...
  10. jcj88

    Updating date-field in database with ASP

    If you are using Oracle, consider using the TO_DATE SQL function to convert your string to a date. I assume other databases would have a similar function but I could be wrong.
  11. jcj88

    Disable Controls

    Sorry don't know an easy way to make it work in Netscape. But you could put code in the onClick of each control (to reset the value after the user clicks the control). That would work in both, but is probably more painful. Sorry... Jay
  12. jcj88

    Questions about mail

    Hopefully this will help... 1. You cannot determine what program a person will use to read an email from the sending-side. However, you can keep the HTML to a minimum so that it will look good most of the time. 2. You can probably only tell if someone opened your email if you are on the same...

Part and Inventory Search

Back
Top