im using ajax to load different pages of code into containers on one page.. i have checked my code.. and things SEEM to be named correctly.. and i know the db is workin because it populates the drop downs properly.
so if you could do this form me.. choose the first radio.. 'london postcode' and proceed from there.. when you click the get quote that error comes up.
I'm creating a database search page and the table I want to search has fields linked to other tables in the database. For example, the job table has a number of fields, 2 of which are area and job type which are tables in the database. My search page has option for searching by job title, job type and job area (via dynamic drop-down).
Do I need to create a recordset for each referenced for the dynamic drop-downs to work
I am trying to do is display 'by tag name' like I have in the code i.e. 'ARTIST'. I was getting the access denied error because I was trying to access a remote XML file, so I created a 'proxy' page (getXML.asp) in ASP which seems to work - in the sense that I don't get that error anymore!
But now it can't retrieve the XML but I am almost certain the getXML file is causing this as teh XML file is where I say it is.
This is my first attempt with AJAX so sorry for being so vague but basically it don't work. Code:
I dont know more about AJAX. Just I wan to know if I want to use AJAX. What I have require to install it. Can i use it with ASP?
View Replies View RelatedDoes anyone know of a site where I could learn how to use Ajax with ASP? I am a complete newbie to AJAX (know the name and that's about it) but am interested to see if it could help my applications. The only help I can find involves ASP.Net not classic ASP.
View Replies View Relatedto run an ajax page on my site would my webserver need asp
View Replies View RelatedI have this code that retrieves the logged in users info. What I also need it to do is to display other records in the database that match the logged in users custnumber. Code:
View Replies View Relatedi'm confused about perfoming insert, update and delete operations in a database. I know that to only use SELECT statement you would create a recordset and use it but for all other you need to use Command or Connection Object.
I'm confused because in some books/articles they create and open a connection and perform insert/update using that. in others they say to use Command object instead. which one do u use when?, why?.
I wish draw data from a MySQL Database using ASP.
The Code I have so far:
<%
dim adoConn, adoRS
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "driver={SQL Server};server=SERVER-WEB;database=testing;uid=products;pwd=starmart"
adoRS.ActiveConnection = adoConn
%>
and in the asp page code:
116. <%=rsDaySummary.fields("PageViews")%>
This is obviously wrong as it returns this error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/stats.asp, line 116
Any pointers would be appreciated.
The following code works fine doing a query in the db and return the data with the link ...mes.asp?month=X (where X is a month and mes.asp is the name of the file that this code is in...)
I have a ID column in the database and would like to know how to catch data from ID.. i have tried without success, dunno why but the code comes with a error in the line "rs.Open sqlStr, data_source"... Code:
i have this shopping cart i'm working on and it keeps giving me this error and the original code is on the bottom. Code:
View Replies View RelatedI am using MS Sql server and asp pages together.The problem I am getting is not knowing what data type to best set my data to.There is a part # set to nvarchar which seems to work great.
THen an Inductance, currently set as float. My inductance values show as 1.5 and 5, 3, 3.2, etc etc, however I need it to show 5.00 and 3.00, 3.20 etc.the inductance is measured in mH and another column called DCR is measured in Ù. Is there anyway to get this symbol to show in my table on my asp page? or do I need to enter the symbol into the database table?
I am trying to create a xml tree using sql server 2000 and asp 3.0 i am looking for a code for it .
View Replies View RelatedI need to know the syntax to achieve the following.
<%
Dim Year_Value_Num = 1999
Year_Value_Num = 1999
rsUsage.Open "Select AuthorLastName,ReceptorName,Year from TblAuthorInfo where Year > Year_Value_Num ", strConn
%>
The database access works fine otherwise But if i attempt the above code i get the error.
anyone know of some good ajax resources working with ASP as most of the stuff on the net is PHP.
View Replies View RelatedI've been starting to dig into ajax a bit and found some great code to pre-load data to page through a recordset. My very dumb question is this - the sample code uses php to connect to the sample database.
Would there be a problem using asp to make the database connection? I'm not getting any javascript errors on my trial page, but I'm not getting any data either, which is what make me wonder.
I put some code together below, so you can see what I mean:rcntech.com/development/ajaxcars.asp
If you test the link above with IE works as it is supose to, however it doesn't display any elements withing the <form> tags in Firefox.
By the way, I am loading the page using AJAX, if you call the ASP directly in Firefox then it works fine, but that's not what I am trying to achieve.rcntech.com/development/login.asp
Anyone know of any good ASP AJAX implementations?Or does anyone have any favorites?
View Replies View RelatedI've seen a lot of autosuggest scripts with
http://www.dhtmlgoodies.com/scripts/ajax-dynamic-list/ajax-dynamic-list.
html being one I've tried to use.However, when used in conjunction with ASP,*something* just doesn't go right.
My web site HTML comes from a database via querystring e.g. page.asp?pid=55. I have a separate asp search page, search.asp. Its output is retrieved by an ajax call from page.asp and its HTML is then neatly wrapped and styled by page.asp.
I want search.asp to recognise if it is not being called via ajax frompage.asp, but directly e.g. via the address bar (and if so, redirect to page.asp). Do I need to put something into the posted string, or (better) is there an asp method that can do this?
The ajax call is
function GetSearchPage(st) {
var poststr = "searchterm=" + encodeURI(st);
makePOSTRequest('/search/search.asp', poststr,'divFullSearchDisplay');
}
Suppose I have an asp page that has a response.write(something) in a loop that would run for a considerable amount of time. Now, from my client browser can I trap those server response messages (using ajax) and print them on the browser?
The thing is the asp page is still running over at the server. while it is running I would want to monitor some variables that is part of the program that is running over at the server.
I don't excactly know whether this is an ASP, webserver or SQL-Server problem:
I have an ASP with a search form. By clicking the submit button it redirects to my result.asp page which initiates a database query that takes pretty long (up to 4 minutes).
Now if I push the cancel button in my browser because it takes too long and want to open another ASP page in that browser window I just get the "page loading" bar until, it seems, the query I initiated before has finished, and then shows up the wished page.
What I think is, that the webserver is waiting for the the command:
set rs = db.Execute(sql_search_string)
to be finished by the SQL-server and does'nt respond to other page requests (but only in the same browser window) until the recordset is filled with the information from the SQL-server. Code:
I am trying to query an Access database using the like operation; however, when I test the query in the browser all records from the database are displayed. Here is my code:
View Replies View RelatedI am using ASP with VBScript. I want to query an access database username
field, and display the output as a hyperlink on an a webpage.The webpage
will display all records. I then need to be able to select a given
record(hyperlink), and display all of the fields for that record on another
webpage so I can execute some code against it.
Can anyone point me to some sample code so I can get an idea of how to
accomplis this?
I'm creating a database search page and the table I want to search has fields linked to other tables in the database. For example, the job table has a number of fields, 2 of which are area and job type which are tables in the database. My search page has option for searching by job title, job type and job area (via dynamic drop-down).
Do I need to create a recordset for each referenced for the dynamic drop-downs to work?
it possible to pull the information from a query located inside the .mdb database already, instead of pulling the information from the tables ?
View Replies View RelatedI have an Access database that I created a query in. The query brings fields from related tables and prompts users to perform a search based on 3 criterias.
NOTE: the prompts can be bypassed by just leaving it blank and selecting OK. So in other words, the user does not need to fill in each prompt for the search to work, it just give them a more narrowed down search if they fill more in...
Now for the ASP part... I want to create an ASP page where the use selects from 3 drop downs. These drop downs are named the same as the field names in my query. How do I get this to work??
I have created a query and everytime I try to run it I get this error:
Microsoft JET Database Engine error '80004005'
Record is deleted.
/vsadmin/inc/incsearch.asp, line 162
This is the query: Code:
I want to retrieve a large number of rows from my database (Select SomeColumns from myDatabase)and then to fill a table with the retrieved data. What can i do?
View Replies View RelatedI would like to know how to go about sending a query to a database when a certain image/link is clicked by the user.
By this I mean e.g. table in a database called cd, primary key in table id. Each image/link has its own id number which refers to its record in the table.
So when the user clicks an image or link i would like it to preform a SELECT query using the id number.
How would i go about giving a link/image its own id number? I guess this is simple as i have seen it on many sites and have seen the query string at the bottom of the browser in status bar when you hover over image/link.
I have created a asp page that allows me to add records successfully to a database using a ajax methods. This works for me but i need to update the data table that is on the same page with the new record without refreshing the page. Does anybody know good methods for vbscript and ajax?
View Replies View RelatedTime is changed and you see almost all ruling companies in INTERNET are using AJAX Based applications. Something that is named CallBack Event in ADP.NET 2.0.Here in this topic i want to start introducing step by step an AJAX-Based application development.
The target is implementing a professional AJAX Grid in ASP. So at the end of this continuous tutorial i will put the source code free. Be in touch to find out how AJAX concept improves our ASP applications.
i thought some of you might be interested because as far as i know there arent any Ajax Libraries for classic ASP...
i have developed a free Ajax Library called ajaxed. With this you are able to call server side procedures directly from client side ...