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: *

  1. paulnew2000

    Passing Data Parameters through ASP

    I have successfully passed userid and password for my SQL Server logon through a script, but I'm not able to get this to work. I called Seagate but they were very little help, though very courteous. This is my current attempt: === Set session("ParamCollection") =...
  2. paulnew2000

    Send username and pass via ASP

    I have been attempting to use an ADO connection, supplying the password and then calling the report. However, it seems that I must open a recordset to connect the report to. However, I can't open a recordset, because I don't know what the SQL statement will be. Any further suggestions? Thank...
  3. paulnew2000

    Know why this is giving me a syntax error?

    Using Preservesinglequotes is the right answer. I was running into the same problem. I tried replace and rereplace, (replacing with quotes or 2 apostrophes)but that makes the situation worse when there is a single quote. e.g. paul's becomes paul"s or paul''s.
  4. paulnew2000

    Know why this is giving me a syntax error?

    I only had to change one(1) thing to get this to work. I placed single quotes around the variable in the WHERE clause. Oracle griped until I did that. What was your error? I like your technique of creating the hidden fields and dynamically populating the name based upon the currentrow. In...
  5. paulnew2000

    Send username and pass via ASP

    I am using CR Dev edition. I have a group of existant, highly comlex reports from an exec. I have placed the reports on a NT/IIS website without a problem. However, I would like to be able to send login (for the datasource) so that my users don't have to. I'm already using Basic login w/SSL...

Part and Inventory Search

Back
Top