Search results for query: *

Thanks for the quick reply - Actual my issue is that I can not just copy and paste that MS Access statement and hope it works just like that on MS SQL? This code was routed for MS Access but table are now in MS SQL and wondering if I need to change syntax? Right now, it's complaining about...

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

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

Thanks guys! Thanks, Ricky

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

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

Thank you so much Gary! Thanks, Ricky

Gary, So if dedicated SSL then https://www.mysite.com else https://secure.theirsite.com Thanks, Ricky

? Thanks, Ricky

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

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

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

Thanks baddos, One more question, where can I find out more of how to use SSL properly. Meaning, I am building a shopping and what should be sent to SSL, only pages like Checkout page, Member Info, etc? Right now my problem is that I have a share SSL and when I redirect a page from non to a...

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

baddos, I have not idea. I did not ask that question to my server guys. Can I find out myself? Thanks, Ricky Thanks, Ricky

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

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

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;))...

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

Thank you so much both. I guess I need to learn more of this stuff. Thanks, Ricky Thanks, Ricky