RS Causing Strange Error
For some reason,, the following recordset rs("w2itd1") will run fine when I'm looping it out on a page, but when I have it inside a sql statement, I get errors.
for example:
sql = " Insert into table (title) values ('"& rs("w2itd1") &"') "
This will give me an error. The contents of this rs is a book title. Oddly enough, however, if I enter any other of the rs("fieldnames") that I have, in exactly the same fashion, I have no problem. There just seems to be an issue with the text coming thorugh. Can someone
indicate what the problem could be?
View Replies
ADVERTISEMENT
I keep getting an error in coding. I am using Dreamweaver MX 2004 and once I
preview it in IE it works then once I press F5 to 'refresh' it fails again.
The IE error returns this link
http://support.microsoft.com/defaul...Q241271&sd=tech
It regards the following : IIS 5.0 Continues to Return 500;100 Error Page
with Response.Buffer Set to False
Does anyone know what this means and how to fix it?
P.S The previous thing I was doing before the problem was setting up 'data
bindings' in DWMX - to be fair this was somewhat a trial and error approach
and I'm not sure if I've damaged IIS or DWMX in someway.
View Replies
View Related
Can anyone help me with this error?
code start ____________________________________________
Microsoft VBScript compilation error '800a03ee'
Expected ')'
/example.asp, line 142
Private Function FuncDiff(ByVal DateOne As DateTime, ByVal DateTwo As
DateTime)
------------------------------------------^
code end ____________________________________________
View Replies
View Related
I just re-uploaded my .asp site to a new host.
But one of my pages now bugs, I get this error message in a Windows alert box:
Redirection limit for this URL exceeded. Unable to load the requested page. This may be caused by cookies that are blocked.
All other pages work fine.
View Replies
View Related
I am trying to run the following query:
strSQL ="select * from fn_select_loads_carrier('"& strCarrierEmail &"', DEFAULT, DEFAULT)"
from an asp page. When i run it on the SQLl server it results me a result set. And also in the asp page all the results are getting displayed properly. This is how i am running the query: Code:
View Replies
View Related
I am trying to run the following query:
strSQL ="select * from fn_select_loads_carrier('"& strCarrierEmail &"', DEFAULT, DEFAULT)"
from an asp page. When i run it on the SQLl server it results me a result set. And also in the asp page all the results are getting displayed properly. This is how i am running the query:
Create_Recordset()
obj_RS.CursorLocation = adUseClient
obj_RS.Open strSQL, obj_Conn ,adOpenStatic, adCmdTable
If strSort = "none" Then
obj_RS.Sort = "LoadID, TMSName"
Else
obj_RS.Sort = "" &strSort &""
End If
If Err.Number <> 0 Then
strRedirect = "Error.asp"
response.write "Erro number" &Err.Number
End If
I am getting the Err.Number as 13 and it doesnt display at which line the following error is occuring. But all the results which the database is returning are getting displayed on the webpage.
I have no idea from where this err.number 13 is occuring at. I crossed checked all my procedures and script.
View Replies
View Related
Im writing a script that has a lot of "nested" IF statements - it breaks a complicated situation down through a sort of logic system, and when it reaches the end of the tree it performs a certain task - in this case, it writes a row of data into a table.
Its very annoying that the IF statements work exactly as I want/expect them to...but when it gets to the end of the tree of IF's I get the following error: Code:
View Replies
View Related
I apply a function to a set of Strings basically as follows formatText(str_title), etc.
I use this same method across multiple pages, and across all of them this works fine, APART from on ONE page.
It is basically extracting the EXACT same variable (with the exact same value) on BOTH pages, and applying the EXACT same function to this variable, yet on one page it is displaying the following error :
Type mismatch: 'reFormatText' .
View Replies
View Related
i am using a ASP application with following things
Server : Intel Xeon (TM) CPU 2GHz, 2GB RAM, 136GB HDD
OS : Windows 2000 Advanced server. IIS5.0
Database: Oracle (Using ADODB to connect to the Database)
App server running on the same machine (COM+)
after using the application for 2/3 hours i get an error message
"Internal Server Error"
once i restart the server it works absolutely fine for some hours.
After encountering the error i opened COM+ and clicked on the "Computers" node .
Then got the following error
"Error Code 80010108 the object invoked has disconnected from its clients."
View Replies
View Related
I have some code on my application like the following:
<%
redirectUrl = "mypage.asp?type=100&id=something&view=10
'some more asp code
%>
<a href="<%=redirectUrl%>">Some Link</a>
the above code works fine but throws validation errors.
the errors are
# olumn 81: cannot generate system identifier for general entity "id".
An entity reference was found in the document, but there is no reference
by that name defined. Often this is caused by misspelling the reference
name, unencoded ampersands, or by leaving off the trailing semicolon
(;). The most common cause of this error is unencoded ampersands in URLs
as described by the WDG in "Ampersands in URLs". Code:
View Replies
View Related
When I run the following code it causes my page to time out This query can onlt return 30 records for any given month I can't figure this out. Code:
View Replies
View Related
I have a field in a db thats a varchar (10).its values pass well in a query string if the values do not begin with 0
134567 passes great
0132 passes another number like 2343 (where it comes from I have no clue?)
View Replies
View Related
I have a project that uses a frameset. On the pageload event one frame calls
an ASP.Net page that watches a message queue. The other frame has a page
that allows a user to submit queries. Through research I've discovered that
IE allows only two connections to IIS from any one client at a time. This is
okay since at any given time I can only have the AJAX thread and a page
request.
I noticed a problem today. If I introduce a session variable in any of my
server side code it causes every request to lock for 90 seconds before a
response comes back. After studying this behavior I am stumped. Is there an
extra thread being fired whenever session is used?
View Replies
View Related
below is the code which is used for adding items and then displays the item
which is working fine i have a problem when i display the item if the user press f5 or does refresh it increases the qty.
so if u look at the code i get the product details from a earlier page if the qty which i get is 2 and then i do a refresh on the page the qty becomes 4 is there any way to stop it Code:
View Replies
View Related
I am trying to update my table with a value passed though the
request.querystring method but as you can see from the sql statement below
it is causing errors.
In this case the name of the department as displayed is "Arts and
Entertainment" but it is giving me something strange when I try to use the
variable
update empprofile set department ='Arts%20%26%20Entertainment' where
employeenumber =219104
Microsoft JET Database Engine error '80004005'
You cannot add or change a record because a related record is required in
table 'Departments'. Code:
View Replies
View Related
I have compiled an activeX dll and pass variables using asp into functions within the dll.
When I test this running the code with Visual Studio the data is output correctly to the browser, however when I compile the code and run the same code the data is different! This is confusing me as to why this is happening....
I always re-start the web service after registering the dll...
Any ideas?
View Replies
View Related
I have a page that lets the users make contact groups and send an email to
them. I have a form that lets the user enter the details of his message
including his full name and his email address. Once this form is submitted,
I do the following to get a string for .From property of the CDONTS mail
object:
Sender = userFullName & "<" & userEmailAddress & ">"
Now I stumbled upon a bug where if the user adds a title to his name (i.e.:
"John Smith, MD"), the address for the recipient gets truncated where the
comma is and the recipents can't reply as the address is now invalid. Is
there a way to encode any special character in the string so that it will be
mailer friendly?
View Replies
View Related
I'm running ASP under IIS 6 with Tomcat. During the process, Tomcat will
forward to an ASP page with some data and those data will be written to MS
SQL and display some information in that particular ASP page. The Servlet
has no unsafe code. The strange thing is that all the data is written
correctly in the MS SQL with correct user and related information but the
data might become blank or send to different users in that ASP page.
Does anyone know what might cause this strange behavior ?
View Replies
View Related
I have developed a site for my client,
eg., www.abc.com
I have registered the domain with godaddy and mapped the dnc to my server (Windows 2000)
When i browse that site using that www.abc.com, in one of the pages i found that the session value is lost. This happens only in some machines not same with all. Most of the machines works that site properly. But not the same in some machines. All machines has configured same.
The exact part is
eg.,
customerdata.asp
session("custdata") = request("name")
response.redirect checkout.asp
in checkout.asp
if i give response.write for that session("custdata"), In some machines i m not getting the value.
View Replies
View Related
**MySQL is accessible via ODBC manager and MySQL -Front. I am able to modify the databse. I can not access database from the ASP page that I did not modiy after the last successful interaction with database**
MySQL 4.1/IIS
Everything was working fine until last night PC shutdown to give it a break, was running for a few days. Today, after reboot, the ASP page, and my entire site for that matter, stopped working.
Here is the connection string that was working:
dbPath = "SERVER=localhost;DATABASE=molsonbubba;UID=xxxx;PWD=xxxx;OPTION=35"
useDSN = False
If useDSN Then
cString = dbPath
Else
cString = "DRIVER={MySQL ODBC 3.51 Driver};" & Server.MapPath(dbPath)
End If
Here is the code that throws the custom error (Database is not found) and stops. If I remove the code I am able to get the site up but no db operations work as I get a "HTTP 404 - Page not found error" ? Code:
View Replies
View Related
Not sure if anybody has run into this problem. I'm using ASPEmail from Persits to generate an email and send it. The problem is that when I check the email that the asp code sent using Outlook Express or Outlook the email gets cut off 3/4 of the way. If I check the email on hotmail, yahoo mail, any other email program....the email comes in full. Any ideas why this might be?
View Replies
View Related
When adding i am checking if that name already exists in the DB and if so i am poping up the message that name already existing.
It is working perfectly in my win2000prof and i have tested in both in my localhost and ftp servers and in both places it is working as i ahve expected.
But when the same application is opened in winxp i have a strange problem coming. When i add a new list , then it checks for the name and what happens is every time i add a new one and even if there is no matching record or matching name avialable for that record, javascript popups saying "Favourite List Name Already Exists" and the strangest part is the insert part also working. That is both if and else part are working together. I am getting this problem only in XP. Code:
View Replies
View Related
A bit of a strange request this, but I do have a reason When using request.form to access a forms elements data, is it possible to btain the elements type.
For instance whether the field (element) its being passed from was a hidden field, a text box etc etc! I've hunted everywhere, and tried lots of variates but I couldnt find anything..
View Replies
View Related
This problem occured just the other day. Whenever I try to access an .asp file on my server with an exact url, I get an error: The system cannot find the file specified.
BUT, if I type in an url to a folder containing a default file (in my case, index.asp) the file is shown correctly .....
View Replies
View Related
Have an ASP page on internet, where I let the user write his email address. Today I see that this text input field has got a yellow background instead of the normal white as the other input fields. The code is quite normal. Using IE 6.0.2900. It has not appeared before. Then I rebooted the computer,but got the same result.When I try another computer, also with XP pro and the same IE, the text input is white as it should.
View Replies
View Related
why a ADO recordset.recordcount would return a -1? I have confirmed that it has records in it by writing some values to the screen. Why can't I count the number of records returned though?
View Replies
View Related
I have the simple form as below. When I click it is not getting the form
action from the line inside the loop but from somewhere else in the page.
The page has multiple forms but depending on what the status is various
elements are dsiplayed or hidden. For examples even If I change the
viewpo.asp to nopage.asp it still is displaying the page and going to
viewpo.asp page with the PONumber query string set. Code:
View Replies
View Related
I have a Website at work which we use for logs. You must login to access anything. I didn't change any code on one of the 9 pages I have and all of a sudden, the Submit button won't work. I'm totally stumped as to why. All the other Submit buttons work fine on all the othere pages.
View Replies
View Related
I have an access database with lots of fields including a memo field called
'priecinfo'.
Everything works well, lots of data is written, but in one particular
situation, I can't get the field 'priceinfo' to write out:
1) the code below works properly except that the field 'priceinfo' doesn't
get written - replace it with any other field and it works. Code:
View Replies
View Related
On the same client with different IIS servers I got a different behaviour of the same code. In one environment it opens in the frame and in the other it opens a new window.
Action Codeline: <Form action="show.asp" target="show" method = post></Form>
Show Codeline: <Frameset><frame src="show.htm" name="show" scrolling="yes"></frameset>
View Replies
View Related
i'm getting an instance of a form field value being cut off when input into a MS SQL db. i can't figure out where it's doing it. the field datatype is set to VARCHAR with a size of 100. the data is being cut at 30 characters. here is the form field: Code:
View Replies
View Related
I wanted to just use standard INPUT buttons and colourise them, but user's
of my web app want to continue creating their own buttons and using these in
css. Before I used straightforward images, but creating an image for each
button was a mare. You see this is all to do with giving people the ability
to change the look of the web app, in other words a skin, using nothing more
than pics and css files.
My theory was that I create a div, span or whatever for the left hand side
of the button and ref the image (in css) to be a 2px wide img that can have
the curved left hand edge of the button.
I would then put a div, span or whatever next to this and the reference
image would be a really long image (horizontally speaking) so that if the
button text was long then this would keep moving to the right and
accommodate basically any text length. Code:
View Replies
View Related
Anyone have any thoughts regarding the output document?
View Replies
View Related
