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