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 Wanet Telecoms Ltd 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: ombina
  • Content: Threads
  • Order by date
  1. ombina

    How to translate from MS Access to MS SQL?

    sql = "SELECT questions.adminID, questions.questionID, questions.surveyID, questions.question, " sql = sql & "Sum([rbt1r1]/1) AS t1r1, Sum([rbt1r2]/2) AS t1r2, Sum([rbt1r3]/3) AS t1r3, " sql = sql & "Sum([rbt1r4]/4) AS t1r4, Sum([rbt1r5]/5) AS t1r5, [r4r5]/[Total] AS...
  2. ombina

    de dupe records???

    Hi, If I have: 222 222 333 333 333 444 555 555 How can I make it unique. Thanks, Ricky Thanks, Ricky
  3. ombina

    Script Time Out redirect?

    Hi, Please help. I need to know how to redirect when an error occur, in this case Script Time Out. Thanks in advance. Thanks, Ricky
  4. ombina

    Crosstab in ASP?

    Hello, Anybody knows where to find crosstab query examples? Thanks, Ricky
  5. ombina

    SSL and new Session.SessionID in trouble!

    Hi, I have a problem where my shopping cart depended on the Session ID to query the data entered into the database. Basically, I'm sutck now where the Session ID changes as it goes from HTTP to HTTPS mode. Any advice on how to do this difrrently or a quick solution? Thanks, Ricky
  6. ombina

    (request.queryString) howto NOT repeat vars?

    Hello, I just wanted to know how to take out certain vars? Example - url: ?id=1 hyperlink: ?(request.queryString)&newLink=1 If I keep clicking this link, it keeps repeating my newLink=1 value. My goal is NOT repeat this value. Thanks, Ricky
  7. ombina

    Cumulative total please???

    Hello, I am trying to calculate cumulative total: Final output - Col1 Col2 ==== ==== 1 1 2 3 3 6 4 10 5 15 . . Thanks, Ricky
  8. ombina

    SSL on cart changes Session.ID...Help!!!

    Hello, How do I prevent redirect page from changing SessionID value? My cart is SessionID dependent. Thanks, Ricky Thanks, Ricky
  9. ombina

    HTTPS loading pages very sloooooow...help!

    Hello, I'm wondering if I'm doing this correctly: Login page redirects to Member Area - - I code it where login.asp redirects to member_area.asp if the login info passed Currently, Member Area is not in secured but I do have SECURE server allocated. Question: If I redirect it like this...
  10. ombina

    How to email as saved on SQL field?

    Please help. When I email me letter format TEXT field, I received unformatted letter form. Meaning my line breaks are joing together as one huge paragraph. How do I send this through email such as JMAIL so that I receive it nicely formatted? Thanks so much! Ricky Thanks, Ricky
  11. ombina

    PDF binaryWrite garbage!!!

    Help please. I'm trying to read PDF within browser but I get text garbage. Code: <% Response.Buffer = true dim objStream set objStream = server.CreateObject(&quot;ADODB.Stream&quot;) objStream.Type = 1 'adtypeBinary objStream.Open objStream.LoadFromFile(Server.Mappath(&quot;test.pdf&quot;))...
  12. ombina

    wrap=virtual does not work - JMAIL

    Hello, I am having trouble keeping the width below 80 characters eventhough I set wrap=virtual. PLease help. Ricky Thanks, Ricky
  13. ombina

    Primary key int from 4 to 10 possible?

    I appreciate you are reading this. I just realize that my Member table has a primary key only up to 9999. Duh! For some reaseon when I migrated it from Access that's how it came aboard. Is it possible to increase from 4 to 10 length? Thanks, Ricky Thanks, Ricky
  14. ombina

    Enterprise Manager open too loooong...

    Hello, I am connecting remotely to my hosting company via Enterprise Manager. It takes about 10 minutes to log in because the hosting company have about 50 databases. Is there a proper connection steps to connect directly to my own database instead of having the program go through all of the...
  15. ombina

    Encrypt / decrypt password into Access???

    Hi, I would like to know if there's a way to sign-in page (username and password) where password is encrypted and save into the database. The goal is not be able to read saved password. Thanks, Ricky
  16. ombina

    Access Unspecified Error!!! Multi user login at one time???

    Please help. I want to know what to put in. I have this: sql = &quot;SELECT * FROM survey&quot; Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot;) rs.Open sql, conn, 3, 3 rs.AddNew . . . rs.Update close... Thanks, Ricky
  17. ombina

    Spanish sql save error!!!

    Can asp and sql save spanish language into the database? Thanks, Ricky Ombina ombina@yahoo.com www.ombina.com
  18. ombina

    Spanish characters, please help!

    Hi, What is the correct INSERT form pass so it won't cause an error? Thanks, Ricky Ombina ombina@yahoo.com www.ombina.com
  19. ombina

    Proper cursor type for multi user log on???

    Hello, I would like to know how can I set the cursor so that multiple user can write to the Access DB(97)? I get &quot;unspecified error&quot; when 50 people log in at one time. Thanks, Ricky Ombina ombina@yahoo.com www.ombina.com

Part and Inventory Search

Back
Top