Search results for query: *

its not the query. The query gives me all 3 records. 2 not active and 1 active. I want to show just the non-active records in the display, show some other static text, and then start showing the active records. But until I can get the orderdetail.active to determine whether or not to display...

I tried if orderdetail.active = false then and got all records if not orderdetail.active then and got all records if orderdetail.active < 1 then and got all records if orderdetail.active = 0 then and got all records I am doing something wrong!

I have (besides being a moron) a problem showing only the selected records that are not active (ie:still pending) The select works and gives me the records that are pending and completed (active = 1). orderdetail.active is bit, default=0, null allowed ...clip & "WHERE ordersubjects.CompID = '"...

I got it. I am a moron. It was in the files security listing, restricted to just administrators-and not the iuser and others to use the file. Thanks for your consideration Cole (the moron)

>>is it https page of http page?? I don't understand this question. The site is HTTPS and everything else works (thanks to your previous help). I can even change the link referred to in the href and get other pages to load and display without a problem. But for this particular page, the new...

I have a page that I originally wrote in MS word (internal office document). I converted to html via 'save as' in MS Word. When put in place for online view and print (offices around country), it won't display, instead it asks for username and password for "" at https://www..... I have used MS...

The problem is somewhere else. Thanks to DNG, we have it submitting the order into the DB, and it is not retrieving properly for some other reason. I have 7 possible orders selected via check box, and 5 of them work with the same code used, but the 2 that don't work must be ???- I don't know why...

It's old code that has run thousands of time a day for 3 years and works for all other orders. Although we are putting the info into the DB, something is causing it to error when we try to display the info so that we can fill the order. Line 14 is: Dim fullname The full first 14 lines: <%...

Yeah! Progress! It nows inputs the info into the two tables (names and such into the OrderSubjects, order info into OrderDetail), and the order appears in the pending orders list. But when I try to view the order (to fill it) I get this error: error '80020009' Exception occurred...

Unterminated string constant /testing/order/bin/processorder.asp, line 96 " daterequested) values ('" & subjectNumber & "', &_ ----------------------------------------------------^ I'm sorry!

Everything you send is helpful. And I appreciate it! I now get this error: Expected statement /testing/order/bin/processorder.asp, line 98 & "', 22 , GetDate()')" ^ the part of line 97/98 that matters: values ('" & subjectNumber & "', '" & Request.Form("COMPID")_ & "', 22 , GetDate()')"

I'm not having a problem with the inserted info containing single quotes that I can't allow, I'm having problems with MY syntax having the single quotes and commas and double quotes in the wrong places. The user doesn't get to put in anything-only select-and then I have to process the order...

I am having a problem with my insert values syntax. Using MS SQL SVR 2K, ASP Specifically, I have an single/double quote, and end of statement error. The below code gets me close, but inserts something wrong into the table (a single quote?) that causes an error when I attempt to view the data...

My apologies for being thick. I read all of your suggestions and tried several things-none of which will get rid of non-alphanumerics. This: objRst("clientref") = Replace(request.form("ref"),"[^a-zA-Z0-9]","_") and this: objRst("clientref") = Replace(request.form("ref"),"\W","_") isn't doing...

So... Can I use objRst("clientref") = Replace(request.form("ref"),"[^A-Za-z0-9]"," ") to find any non alphanumeric characters and replace them with a 'space' Cole

I understand that. Thank you. But that Replace will only fix a problem with apostophes-is there a way to take care of the other problem characters (and what else am i looking for)? Also. would there be a way to kind of globally do this? I have many different pages scattered in 6 different...

DotNetGnat: Next similar problem. Clients inputs data containing name such as "O'Connell" and the apostophe causes similar ASP error and stops processing of page. Sample code: objRst.source = "select * from ordersubjects where 0=1" objRst.Open objRst.addNew objRst("compID") =...

Small LAN, mix WinME(1), WinXP(5), Win2K(2) Consistent loss of network printer after logoff. Particularly troublesome with laptop running XP and connecting to printer served by Win2k box--everyday we have to remove the printer and reinstall. Frequently receive info box that says denied because...

DotNetGnat You have no idea how much you have helped me! Your <%=Server.HTMLEncode(rs1("results"))%> worked perfectly. Thank you very much! Cole

Using MS SqlSvr2k DB and ASP to display via web browser. When the field (data) contains "<full bal", the ASP page stops displaying the data and continues to the next part of the page. Example data: SETTLED FOR <FULL BAL Example result: SETTLED FOR ASP code: <% if Not objRst.bof And Not...