How Do You Read XML, AUTO Recordset In ASP?
I have an ASP page that is reading records from a SQL database and passing them as a string to a DIV. I would like to do that using XML. SQL 2000 has this great XML, AUTO feature that I would like to utilize. My retrieval code goes something like this:
set objSQL = CreateObject("adodb.connection")
set objRS = CreateObject("adodb.recordset")
objSQL.Open "Provider=sqloledb; Data Source=MYDB; Initial Catalog=MYTABLE;"
objRS.Open "SELECT * FROM MYTABLE XML AUTO, ELEMENTS", objSQL
So, now I have a recordset with the XML code in there. How do I get at it? Let's say I want to Response.Write it.
View Replies
ADVERTISEMENT
I have client who has database full of crap. One field in the "property" table is imageurl. I have been able to successfully extract only the file name from the string, such as "2030323.jpg". All images are stored in a directory called "listings". What I am trying to do is to loop through the recordset, and read each imageurl.
If there is an image file in the "listings" directory, then delete the file. It appears that some fields contain imageurls that no longer exist in the listing directory. Here is the code I have so far, I almost had it, as it told me at one point the file didn't exist. Then I screwed up the code and this is where I am at: Code:
View Replies
View Related
I have a problem in my project to read backward start from the last record in my database. I need to display the graph using asp and SQL server as my database.
How can i set in asp coding to read from the last record then go to the previous record before i can display the graph... Code:
View Replies
View Related
This seem to be a simple question, but I'm having no luck with Google
keywords...
I have an some ASP in which I open a recordset via a connection to a MSSQL
database. I don't want to keep the database connection open while I'm
processing the data from the resulting recordset.
Is there a method that I can use to copy the recordset into an array
(collection, etc), the close my DB connnection and finally process the data
I copied from the recordset?
View Replies
View Related
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
View Replies
View Related
I have created a forum, in which I have 3 tables:
1: Table_Forum
2: Threads
3: Replies
I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
View Replies
View Related
i have a page with top frame (html) and bottom frame (asp)the top frame come with choices and then submit value to bottom asp page by submit button.how can i do it if i wish the bottom asp to run automatically in specific value when the html is loaded.then the user can change the choices after.
View Replies
View Related
Is it possible in ASP to have an Auto Fill option? For instance, if I am typing in a name and I type in the first few characters, can ASP recognize a similar name in the database and begin filling in the rest of a possible match?
View Replies
View Related
ive got an online system which allows people to enter info into a database about an absence request they have - at the same time this emails the person in charge of absences.
The form is setup now but to make it easier i want to alter the "Name" and "email" fields so they require no filling in ie - a staff members name will be chosen from a drop down list (ive done this bit fine) and then once this is done the relevant email for this person is automatically placed in the email field. This bit i am struggling with - anyone any ideas how this can be done??
View Replies
View Related
does anyone in here got an idea on how to automatically send an email message once a person signs up for a website? i'm doing a small website right now and if a person signs up on the website details about the non profit organization would be send automatically to their email.
View Replies
View Related
In my form I placed a text box, in which I want when the users writing something some choices from a database table to be presentes for example:
if they wrote
G
a drop down list to be showned which contains.
View Replies
View Related
I am running 2000 server, sp4, IIS 5
I need to be able to autoexecute an asp page from a batch file that is placed in the windows scheduler.
I can execute the page fine, but I can't get past the authentication. How do I pass the username and password to windows via the URL automatically so this can be done without any user action? This is not a https but it uses integrated windows authentication.
View Replies
View Related
I work for a large company and the outside supervisors are not that computer savy. The simpler the better. Each supervisor has 15 employees that he must assign work for each day(Monday through Friday and sometimes Saturday).
I am trying to create this so they can click on a button it will add 15 new records to Table A that are copied from the day before. Then they just have to update the new records with today's LocDate and a new location if needed. Code:
View Replies
View Related
I have a an url to file in one page and when user clicks, it takees them to another page, say url.asp?ID=...
On this page i want the download to that file to start automatically. the purpose of this page is to record the number of file downloads. is this possible in asp, or is there a better way of doing this?
View Replies
View Related
how to make a window explorer closed tiself like after 1 min? I think I rem there is such function available but I had forgotten the function/code...
View Replies
View Related
I would like to write an ASP script which will auto-login me to a Yahoo account or some user account which needs a username and a password. How can I make this possible using ASP?Or is there any way to get auto-login working?
View Replies
View Related
How can you get cursor to "jump" from the first field that has focus onto the following one and so on, and is it possible to do so if fields sometimes might be empty and if so how would I take care of that?And is it possible to make autotabbing if the field is not a set lenght, I have only come accross examples where the field is expecting to receive a certain number of characters?!!!
Can you use the option of auto tabbing only for input field or it can be done for select options as well?
View Replies
View Related
I am currently developing a web form for the transfer of assets between departments, which will store information in an Access database. I currently have the form created and I am working getting the transaction processing portion of it going.
Basically, there is a minimal amount of information that needs to be entered into the form and I would like the rest of the information to auto-fill. So for instance, I would enter the asset number of the asset to be transferred, and said asset's serial number and description would fill in automatically. I have go this working in Access, but I'm at a loss for how to do it with ASP.
I think that I need the script to execute after a change is made to the AssetNo field, but I have not been able to get it to work how I want. Code:
View Replies
View Related
I am in the beginning phase of a project that will require automatic email reminders to be sent out. Has anyone had any experience or suggestions that might help me get started in the right direct. My project will use the following.
ASP/VBScript/SQL Server Express
Once a record has been added the Auto Email reminders will be sent every 24 hours for the first 3 days or until the receiving party has responded to a questionnaire.
View Replies
View Related
i am auto numbering with sql in asp. my auto code worked but i am restructing my tables and i came across my auto numbered fields. my question is when you use auto number does it give an default field length in mssql and if it dose how do you specifi how long you want the field to be.
here is a sinpit of my code for a table using auto numbering.
sqlStr = "CREATE TABLE Consumer(Con_id INT IDENTITY (1,1) NOT NULL PRIMARY KEY, "&_
"Con_Fname VarChar(25), "&_
View Replies
View Related
i want to call another asp page from my aspx web page in the form load of aspx page and populate certain values in the aspx page based on the results returned from asp page.. I have to pass certain parameters like username and password to the asp page and the asp page should be submitted automatically . How to implement the form submission of asp page automatically from the aspx page. Based on the seach results, certain fields in the aspx page should be populated.
View Replies
View Related
we have an Access database of our clients. It has fields for email addresses and date of expiry of their rents. I would like to write an application that would email our clients automatically according to the dates in the database fields, giving notice that their rent is about to expire like for example, within one month.
I just would like to ask if you could somehow give me some idea or point me to a website that will give me insights. Thanks very much indeed and hoping for your kind response.
View Replies
View Related
I have no background knowledge in this area as yet.In ASP, is there a way to have a set of code to automatically redirect to another page in a given time period? eg: auto redirect to another page in 10 seconds.OR does it has to be done using javascripts or any other scripts?
View Replies
View Related
I have a form which submits it's data to a hidden page(submit.asp).Submit.asp retrieves the data and submits to the db.Immediately once it has submitted data,it will then retrieve the auto generated id for the data just submitted.(hope this will work)
Once I have retrievd the auto gen id, I want to then pass this id to *another page*. I don't want to then create the table on the submit.asp page as there is a huge amount of code there already-want to keep things clean.
How do I pass the value to another asp page?Is it something like response.redirect and how do I attach the id?
View Replies
View Related
On my website I have users create an account. After they have created the account they have to log in. Is there a way that after the user has created the account it automatically logs them in?
View Replies
View Related
I want to refresh a page every 5 mins without the users' intervention.I'm not sure that this is possible at all.
View Replies
View Related
Can I make the screen state where it is after a control is auto postback? And how?
View Replies
View Related
Just a quick question, is it possible to automatically upload files to an FTP account via ASP? Ie if you have a link say, on an ASP page, saying Upload files now... and basically this would automatically upload a set of files which will be pre-set in the code... to an FTP account for which we know the address, username, password?
View Replies
View Related
I have a few .asp pages in a framed website. I find that sometimes the .asp page reads from my cache instead of refreshing the Database fields when flipping between pages using a naviagation bar in a different frame. Anyone know a little line of code that I could place at the top of my pages that will maybe automatically refresh the page ONCE - when someone enters the page ?
View Replies
View Related
I have created a form with asp, and I want to enable the autosuggest in my text boxes using a MS SQL database as a source for the suggestions. So do you have anything in mind to suggest me to use?
View Replies
View Related
Here is want I want to do. Create an asp script that can:
1.) go to a page
2.) fill in the values needed in a form
3.) click a submit button
4.) use XMLHTTP to capture the contents of the resulting page after it loads
Is this possible, and can anyone point me in the right direction?
View Replies
View Related
I once found a script that would automatically notice changes on your site, and then auto-matically send a newsletter to your users notifying them of the changes, and giving a short description. I know how to do everything but get the changes and summarizing them. Anyone know of such a script (that's free)?
View Replies
View Related
How to create auto responder in ASP.
View Replies
View Related