After Insert - Update Another Site
The data that is entered into my website needs to be sent to someone else. Currently it is being put into a MySQL database. In addition to this, a third party needs this information. They have something set up on their website where I can do this:
https://www.domain.com/update.exe?src=username&data=Smith,John,5,12,Rose,Charlie
I have no control over domain.com. How can I update the record, send the data to this URL, and then redirect the user back to the default page? Right now it just inserts the record and then redirects to the default page. I'm unsure as to how to do the URL bit. I would prefer if the user did not see the domain switch.
View Replies
ADVERTISEMENT
I can't get my site to work when i put my asp scripting into it. I have used CSS to design site but which ever way i place my asp into the site it goes wrong with my design or the asp dosen't work. Code:
View Replies
View Related
I writed a site in ASP. I use screen scraping to take information from other site and put them at my. The problem is that when i want to update those information i need to use a button.
I want to make this more "automatically", like at 5,00am every day without me. Is that possible to program such actions directly on server where my site is uploaded?
View Replies
View Related
this programe is read date for excel and export to mdb,if there exist the BID in mdb then update the date,else inert the date to mdb. Code:
View Replies
View Related
I have a form that pulls existing information from a database and allows users to edit it. Every field can be left blank if the user wishes.
I am having an issue with determining which SQL statement to run. There has to be an easier way to do this then what I am doing. For each filed I process the data this way:
SQL2="select * from 1985ClassList where MailingListID =" & Session("EID")
set aData = oConn.execute(SQL2)
Code:
View Replies
View Related
I'm using a database to store the products in a basket.
It's this scenario:
A visitor already has some products in his basket and wants add some new ones.
Now, first I want to check if the selected products aren't already in the database.
1. if they are -> update the product when the amount number is changed
2. if the product is not in the database then insert it.
I'm stuck at the point that I can't retrieve if the database is updated, so I can either stop the query or insert the new product.
Java has a statement like getUpdateCount(), but ASP/VBSCRIPT??
I want the fastest solution, i dont want to retrieve the data twice and compare them to check if it changed..
View Replies
View Related
I try to do an INSERT statement throught my ASP to add records to my Access DB. However I get an error when I execute this. The code in ASP is -
strSQL = "INSERT INTO tbl_psm (LocID, Week, Month, Year, Rating, Remark, Action, SubmittedDateTime) VALUES ('" &cint(intLocid)& "', '" &cint(sWeek)& "', '" &cint(sMonth)& "', '" &cint(sYear)& "', '" &cint(sRating)& "', '" &sRemark& "', '" &sAction& "', '" &formatdatetime(date,vbshortdate)& "');"
objConn.Execute strSQL
I get the error page Code:
View Replies
View Related
I am submitting a comment box from a form into a database field that I have declared as text (16). When I type in a small amount of information, it submits just fine, but when I enter a substantial amount of data then I receive an error. I've tried different field types, but I keep getting the same error.
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 's'.
View Replies
View Related
I have to compare 2 tables: orderA and orderB, if the record exists in both table orderB and orderA, just do a update to the quantity field in orderB (add orderA.quantity to orderB.quantity). Otherwise a new record has to be insert into orderB.
Do I have to loop through the recordset of orderB, then use select statement to see whether the record exists in orderA or not, and determine whether to update/insert record? I am using Access database. I just afraid that looping through each record in recordset (maybe >=30 record each time) would make the transaction getting slow (or even hang??). Can I do this in one SQL statement?
View Replies
View Related
I want to insert the element selected by the user from the drop down box in the DB(Access).Once the user hits submit i want it to insert this in the DB + i want to update one of the fields from True to False . how can i perform both these at the same time?
View Replies
View Related
After the page (transactions.asp) loads I want to allow the user to enter the number of transactions into the provided textboxes. Then, when the user clicks submit, I need to have all the hidden fields as well as the number of transactions values inserted into the transactions table of my database?
I have attached the database should you have any questions about the db table values and fields. Please let me know if you have any questions or need more information or files.
View Replies
View Related
can u tell me of a simple script i can use to do the following. I want a textbox to add a entry to the database with a submit button, then below all that the current database entrys are listed below also in textboxes with a UPDATE and DELETE button beside each entry.
View Replies
View Related
I didn't know how to use asp to update or insert the excel data ....
View Replies
View Related
I have a problem that it's bothering me for some time now and i will need a lot of help from you. I don't know how easy or difficult it is to be done but i would appreciate any help.
I have an mssql 2000 db with table "table1". Attributes for "table1" are:
ID (Primary Key)
field1
field2
field3
field4
field5
field6
field7
I'm trying through DreamWeaver MX to create a form through ASP and Text Fields, so that i can update "table1" through the form and also on another page to show the results of my table.
I have created a form which will be accepting 25 rows, each row having field1, field2, .., field7.
I cannot seem to get it to update "table1".
Any ideas how this can be done?
View Replies
View Related
I am storing dates in a mySql database in the format yyyy-mm-dd. Now, I have set up so that this field is insert by a form.
It isn't very user friendly to have to type yyyy-mm-dd, how can I set up so that the user can enter format dd/mm/yyyy and it will automatically insert into the database as yyyy-mm-dd? I am using Dreamweaver MX 2004 and ASP.
View Replies
View Related
how can i make the function return true only if the execution is successfull (see bold red below)? Currently the function is returning true wheather it is successfull or not. Code:
View Replies
View Related
how to declare session variables and use it in insert and update sql statements... the scenario is I have:
2 html forms
2 ASP FILES
I am able to trap data from the first form into the acces table..but my second form(which is continuation of first form) has a update query....(ie...it shld update the same record the one inserted from the 1st form )..both the forms work on table in access db
its an annonymus...questionnaite...therefore i am not trapping any user name or login id...but the requirement is the survey made shld be unique....as in no user shld be able to answer the questions twice.
View Replies
View Related
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
View Replies
View Related
I am to build a site onto an ASP server. Anyone here used Dreamweaver and is it just a simple matter of opening up a new ASP page in Dreamweaver and build the site like you would normally do with a HTML page and it will handle the ASP coding accordingly and you can just simply upload it onto an ASP server and it will work?
The site I am to build is basically just a standard html website, but my friend wants me to build it for an ASP server so he has asked me to make sure it is an asp site so I am presuming with the extension .asp
If I build it as a html site to begin with, will converting it to asp be hard. Could I just export my pages into asp or is there more to it?
Can a Html website be loaded and working on an asp server or host?
Is it possible to have a site mixed both html and asp, eg. the home page is html and when you click on shopping cart on the home page it goes to a hopping cart page thats .asp or do they all have to have the same extension.
View Replies
View Related
I have to pass form data from my site to another organizations site using POST method... how exactly do I do that? Im familiar with how to do it within a single site/domain, and cant use querystring... I dont know where to begin.
View Replies
View Related
Whenever I do a site that is mostly static but with some semi-dynamic
sections, I've struggled to find a good site search solution without
paying for a hosted search service.
I like the FSO-based search engines, but they fail to pick up on some of
the dynamic part.
I was just creating a Google sitemap and it made me wonder: has anyone
created or seen a script that uses the XML Google sitemap to power a
search engine for your own site?
Seems like if you were keeping it updated for Google, why not use it for
your own site?
View Replies
View Related
How to prevent duplicate values when using BULK INSERT to insert CSV to SQL Server? Code:
View Replies
View Related
Okay there is an unique EventRegID for every registration. When people first register they get pre-registered. Then an admin comes in and confirms or wait list them (based on whatever requirements). My question is how can I tie the EventRegID to a form with multipule ID's so they can batch confirm or wait list the PreReg list? Code:
View Replies
View Related
How can my members log out of my shopping website? I can't seem to figure it out. I'm using a session cart where users can log in before shopping or log in upon checking out products. How do they log out??? I'm using ASP and oracle sql.
View Replies
View Related
I would like to create a site map for my map site which is in ASP. I tried
to use Visio to create a web site map but it fails because my asp home page
requires to authenticate. Is there any other tool to create a sitemap from
username/password protected website?
View Replies
View Related
I want to open a website let say
google.com in my own site.but i want to replace some of its images with my own.
but remember site ( google.com ) will be running in my website everything should be of google but look will be mine.i wanted to do it for my own two websites i just used name of google.com to demonstrate my problem
View Replies
View Related
some code to look through for getting started, i still need to sort out thing like a file to hold all the db stuff so i can call the functions rather than type it every time. cleaning up really .
View Replies
View Related
i have a slight background in HTML and basic web dev. I have been asked to create basically the following, it will be my project over the next couple of months. I basically want to build an e-commerce website that will take all data from a database. It all needs to be dynamic, products added to the database would automatically update in the website, the navigation also needs to be dynamic, it needs to be low maintainence, i aim to have the checkout to save customers details to a seperate database, the payment process would have completed, no payment details would be saved.
What do you think on the above. Does any one have firstly any code they may be able to give me, to help me along the way. it does need to be done on a budget, I will buy code if need be. What is the best program to develop such a website in?
View Replies
View Related
I'm looking to eliminate all lag on my site and I have a couple questions regarding databases. Is it possible to open 2 ADODB connections at once? I want to put my sites boards on a different database than everything else but I want to get user information to update in the main db. How would I go about doing this?
Does closing all the stuff you opened in your ADODB connection make a difference? Does it resuly in the use of more bandwidth and site lag?
View Replies
View Related
i have been asked to create a 'site map' for an ASP / Access DB website which i have just started. Can someone explain to me exactly what a 'site map' is and what it is useful for please?
View Replies
View Related
i've got a local server on another pc (ip address:192.168.1.243) but when I want to connect to ASP site that's on that computer it can't. when type "http://192.168.1.243" in my browser it returns this:
IE says: "impossible to find the page" and Firefox says: "the operation timed out when attempting to contact 192.168.1.243". I know that ASP works, because when we try it on the localhost it works (but that's not my computer so I can't use it).
View Replies
View Related
How create site with webmatrix with MySql ?
View Replies
View Related
i have a simple asp counter in my site, the counter uses a access db & cookies (so every visitor will be counted once).
in the past days the counter has gone wild & count goes from 300 in ordinary days to 1000.
i guess this is because of robots, crawls, worms etc. is there any way i can count only real visitors?
View Replies
View Related
