Is it possible to fetch data records from other website and store in a
database dynamically.
I mean to say i want to fetch data from a yellow pages website. showing records of different companies.
i.e, http://www.website.com/data.aspx?Co...1&DirectoryID=2
So, now I want a script which goes on this path and copy data after that go on next page which is CompanyID=3&DirectoryID=2 and follow the procedure.
I need to run a query to get records with date within 30 days from current date.What I used to do with SQL server 2000 was the following:
Date30More = Date+30
MPQry = "SELECT * FROM SOP_T where Rev_Date < '" & Date30More
This stops working with Oracle because Rev_Date in Oracle is in the format of "DD-MON-YYYY HH:MM:SS PM". Therefore, I received an error message as the following:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Oracle][ODBC][Ora]ORA-01858: a non-numeric character was found where a numeric was expected
I'm looking to display information pulled from a database based on information the user puts into a text box. The user will enter their sales rep number and I want to hit a table and return their name as soon as they tab off of the text box.
View Replies View RelatedCan someone tell me if it is possible to store the contents of a TEXT AREA
field in HIDDEN FIELD in another page after the initial form containing the
textarea is submittted....
I need to do this to seamlessly present the submitted data in an attractive
format while hiding his submitted data in the hidden field...but I am not
sure if there are restrictions of eg 255 characters for a hidden field?
Im creating mcq questions using asp and have problems in storing the scores into my database..
View Replies View RelatedI am just wodering in asp program, if there is anybody writing store procedure for inserting data into database since there are so many parameters need to be passed into store procedure(assume there are many columns in the table).
I need to insert data into two separate tables, the relation between these two tables is 1 row of data in table1 could have multiple rows in table2 related to table1, but if the data insertion into any one of the tables is failed, the transaction will roll back and no data will be remained in any of the tables.
If this needs to be handled in asp program using transact sql, how do I implement it. If I need to it using store procedure, how do I pass the error or success signal to asp program from database.
my asp application want to read data from www.kse.net.pk how this is possible?
View Replies View Relatedif there is any way of getting some HTML (lets say for example a table) from another website and show it on your own website automatically ? It would be good if you know how to do it on ASP .net but PHP also can help.
View Replies View RelatedI am having an Excel where I maintain my data. I want to extract details from a website based on the data that I have in my Excel(i.e login to that website,post the data to the Website and get the details from the page n update it in my excel). How can I do this?
View Replies View RelatedI have an csv file with two colums...tiff name & ref no
each tiff name has a ref no and at times, various tiff can have 1 ref no. What i want to do is create and asp script which will go through col2 of the csv file and and add an incremental no at the end of the ref no if it already exists Code:
I have a data base that I wish to add a record to. I have many fields to ender, but I was testing my code with just one and it works just fine : Code:
View Replies View RelatedWhat are the ASP codes required to fetch files from a remote location?
View Replies View RelatedI have a webpage with a form. This form submits data that goes to a mdb file
(id (AutoNumber), name, email contry etc.). I would like to make another
page where I can type the ID number and it will show all the fields only for
that id.
query = "SELECT table. * FROM table where table.lastname=" & lname
How can I fetch all the rows with the lastname field equals to lname variable?
I want to save the details of phases. On selecting a phase, there are 3 columns, task ,start date, end date in a row. Next to it, a button'Add task' is displayed. on clicking this, another row appears below. When i click submit, the data is saved if the following condition is truw: The end date should not be less than start date. how do i retieve the data of all the rows.
View Replies View RelatedI'm trying to make a sorting feature for my site which will allow the user to click a drop down menu, click the item they only want displayed, click a button, and then the results will only display that particular item.
I also would like the drop down menu to auto-fill because there are about 20 different categories available. is there and easy way to do this?
I have an excel file having textfields, I want to get its value from the ASP page. What is the way to get it?
View Replies View RelatedI've a large database that I am working with. The problem is right now I've so many sample data in the datbase all the testing data in it. I want to clear the database and reset the AutoNumber so that it starts at 1 and goes up by one.I know that its possible in Access and I've done it before, problem is the tables have relationship and lots of them.
the way I know to rest the AutoNumber require me to break the relationship but it will take very long time for me to rectreate them again and I might not get them same at the end.Is there a way to rest the AutoNumber without having to break the relationship?
im trying to connect to access and display some infor. from table. but it cant work, many errors occur, saying dat the<%language="VB" runat="server"ris not found in server. what i need to add in so that i can take infor. from acess? some codes.?
Example:
SELECT* FROM Detail... bla... bla... bla...
A client has an OLE field called Signature in an Access database. The field contains a GIF image of a scanned signature (that a product has been received). How can I show this on an ASP page?
View Replies View Relatedwhenever i fetch any numeric value, having a zero at the end, e.g. 32080, from a database with a recordset object, i find that the value becomes stripped of the last zero, i.e. it becomes 3208.
View Replies View RelatedThere are 26 prizes available in a competition a client is running and he wants to be able to select these at random.
I thought the best way of doing this would be to construct a simple ASP page which displays 26 random records from the database.
The fields I wish to display are called name, email and address, and these are located in the table called Competition (this is an MS Access db).
I have a text box when user type (Name) on it and push search button,if
database has this name information such as(phone, address,...) comes in
several text box, if user want to update these information ,change text
in text box and save it, I couldn't write the update code for this
situation,
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
The problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
I'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
how to write store procedure in asp?
View Replies View Relatedwhere I can find an asp script(free) to do a store locator.
I've only been able to find 2 on the web, and they are both at a cost.
I am looking for some ASP - SQL server 2000 online store application that i can buy for my company. This store is completely internal for the company and will be on our intranet server and will be utilized by the company employees to buy company merchantdize.
Also at this time there will be no credit card processing as the amount of purchase will be deducted from the payrol. I will be needing the shopping cart and product view. Later if we provide the credit card processing, we have already installed PayFlowPro from verisign and do creadit card procesing on our main site.
Does any one know such application that i can integrate with our style sheets and general layout?
I am using ASP and VBScript to access an Oracle database and display query results to my users.
However, my query is huge! and I want to keep the query separate from my ASP/VBScript code.
How do I store the query on one page and then call it from another page?
I have this problems regarding "storing New values into session".
Take the "online movie tix booking" as an exmaple. When i click on one seat, beside storing the seatNo into a session, i also want to store the number of seats he has clicked throughout. How can store the incremental of seats clicked into a session by overriding new Values
i am stuck with the following error message
"Application uses a value of the wrong type for the current operation."
did anyone know the reson this occur?
just because of my store procedure....
I have an ASP page and a Store Procedure but I keep getting this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'sp_searchresultsZIP' expects parameter '@xDateTo', which was not supplied. Code: