Double quotes shouldn't affect an SQL string, as string delimiters in SQL (for SQL Server at least) are single quotes, or apostrophes. To escape our...
Hi All, I'm new to the list and to ASP in general. Can anyone tell me of an easy way to interrogate three search engines at once and direct the response into...
OK, a picture is worth 1000 words? Here is the dev site http://204.116.141.10/triad4wda/ I set up a user.so you can try it to see what I mean. User: asptest ...
... View the source for http://204.116.141.10/triad4wda/modprof3.asp and it has <INPUT type="hidden" id=PersNotes name=PersNotes value="There is no such thing...
Yep - that's an HTML problem, not SQL. As Adrian suggested, do a replace to replace double quotes with """ before storing it in the hidden input element. ...
Dear Group I have a small query. We have an online bids page where once submitted it will be sent out as a HTML email. It has some text boxes and list boxes....
Help I converted all my pages into dynamic. I removed & deleted all the subfolder with old static pages. How can I redirect all requests for the subfolders to...
Use a custom 404 page. I read your message, by the way. Ray at work ... ********************************************************************** This email and...
Costanzo, Ray
rcostanzo@...
Apr 1, 2003 6:21 pm
5086
Hello All: I have fought through several problems but have encountered the following error. Can anyone advise as to a solution? Thanks Jesse ADODB.Recordset...
In IIS setup a redirect for the directory... ... Help I converted all my pages into dynamic. I removed & deleted all the subfolder with old static pages. How...
Brian Hitney
bhitney@...
Apr 1, 2003 6:56 pm
5088
Jesse, It might be that you're query passes a string (Location_Parcel_ID = '" & strParcelID & "') but your database field is an Integer/Number field. Try...
A while back, someone on this forum suggested the Dictionary object to me for a design problem I was having. This is my first use. However, I cannot get it...
All is well if I do " UpdateBOM PageBOMDetailsRS("Description").Value" instead of " UpdateBOM PageBOMDetailsRS("Description")". I don't know whether to be...
What is "db" on that line? ... From: Jesse Ackerman [mailto:jackx135@...] Sent: 01 April 2003 7:53 To: active-server-pages@yahoogroups.com Subject: [ASP]...
Thanks all - esp Adrian for getting me pointed in the right direction, The answer was to Replace the Double quote with " The missing ingredient was Had...
The reason it was a problem was not to do with the insert statement, but to do with your hidden field. Basically you had a hidden field with a value with...
Jesse, In the email your where statement is broken into two lines. Is this the way it is in your code? If so, you need a _ at the end of the first line. ...
I have a dilemma. I am trying to set up a site that contains various applications or subsites. There is a global username/password database and the login...
Hello Guys I have been charged with converting an Access application that uses Queries into Stored Procedures on our SQL Server. On some of the Access...
I don't think I was perfectly clear. The problem is that I want to keep the different sites/apps in different directories. I could even combine everything on...
What fields are included in your query. Are the fields based on one table, multiple tables, etc.? What do you want the query to do in the stored procedure? ...
Hi, My name is Nancy,and I just joined in hopes and prayers, someone can help the moderator owner and myself her trusty co-moderator with a Group Database...
hi what does "db" contain? the way u r writing the query seems to be correct. how r u opening the connection? there must be sumthing wrong with? ... ...
Neetu Rastogi
neeturastogi@...
Apr 3, 2003 4:47 am
5102
... Any change you could post the whole query? I'm struggling to get the context and if this is an assignment or an evaluation....
Am I right in thinking you are having problems with the "Database" function of YahooGroups? If so then the servers are something they control and there isn't...
Thanks for your replies. The question concerning the db argument was in the correct direction. db comes from my connection which is in an "include" file: Dim...
U still havent answered my query - is Location_Parcel_ID a text fld or a Number (int,double) fld? ILyas ... From: Jesse Ackerman [mailto:jackx135@...] ...
Yes it is the Database function in Yahoo groups BUT yahoo doesn't seem to be able to fix the problem so I was hoping that some help could be found else where....
I have this code: 'add record to the Detail Table rs1.addnew rs1("Link") = Request.QueryString("link") rs1("LoadNumber") = Request.QueryString("Load") ...