I am using this code to produce a distance from two LONg, LAT from two different tables. Can any one help me write the code so that it can pull from the correct tables and then insert into one field in on table. Code:
View Repliesi have ASP form and 2 tables in access database, table1 has 4 fields st_id,st_name,email,tel) st_id is a primary key table2 has 4 fields (id,car_no,car_mod, st_id) id is a primary key.it relates by st_id i want to add a new record and it should save into 2 tables.how to insert into the tables by submiting from the same ASP form.
View Replies View RelatedHow to insert values in a form to two different table in database? how the sql statement looked like? is it looked like...
sSQL = "INSERT INTO SalesOrder (OrderDate, SalesOrderNo, CustomerName, TelephoneNo, EstimateDeliveryDate, DeliveryDate, CatchFishDate, Destination, Remark) VALUES ('"& vSalesOrderNo &"', '"& vCustomerCode &"', '"& vCustomerName &"', '"& vTelephoneNo &"', '"& vOrderDate &"', '"& vEstimateDeliveryDate &"', '"& vDeliveryDate &"', '"& vCatchFishDate &"', '"& vDestination &"', '"& vRemark &"')"
sSQL = "INSERT INTO SalesOrderItem (OrderDate, SalesOrderNo, FishName, FishType, Size, Quantity, PackingList, ConfirmQuantity, Destination, Remark) VALUES ('"& vSalesOrderNo &"', '"& vCustomerCode &"', '"& vCustomerName &"', '"& vTelephoneNo &"', '"& vOrderDate &"', '"& vFishName &"', '"& vFishType &"', '"& vSize &"','"& vQuantity &"', '"& vPackingList &"', '"& vConfirmQuantity &"', '"& vDestination &"', '"& vRemark &"')"
conn.Execute (sSQL)
I need help inserting the same inormation in second table called "users"
' insert to customers table with retail type by default (admin can change to BtoB later with BackOffice)
mySQL="INSERT INTO customers (name, lastName, customerCompany, email, city, countryCode, phone, address, zip, password, state, stateCode, idCustomerType, active, user1, user2, user3, bonusPoints, idStore) VALUES ('" &pcustomerName& "','" &pLastName& "','" &pCustomerCompany& "','" &pemail& "','" &pcity& "', '" &pCountryCode& "','" &pPhone& "','" &pAddress& "','" &pZip& "','" &pPassword& "','" &pState& "','" &pStateCode& "',1," & pActive & ",'" &pUser1& "','" &pUser2& "','" &pUser3& "',0,"&pIdStore&")"
call updateDatabase(mySQL, rsTemp, "customerRegistrationExec")
I have 3 tables and they are linked with each other.
table 1 (ID, Title)
table 2 (QuestionID, ID, Question)
table 3 (AnswerID, QuestionID, Answer)
the problem is that ..
I insert the question in the correct place which is related to the table 1 but when it come to insert the answer for that specific question id didn't work .. it always take the first question in the table Code:
ContentID is primary_key ID and it is automaticlly created upon this insert, but want to also insert that content id in table Category column ContentId. Code:
View Replies View RelatedI am having problem inserting the auto_increment id (FID) of table "TOPIC" to FTopicID of Table Msgs. Code:
View Replies View RelatedJust 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.
I am working on a search which is used to search for something in cities of US.I want to add an option of "include nearby cities".When the user checks this it should bring up the cities near to that also.
so if the users enters city " LOS ANGELS " and state " California".It should bring up some results in california as well as cities near to californai.
Also i have another requirement in this search which is distance search.User will search for something with the option of with 5 or 10 or 15 or 25 etc., miles , so the same above results should occur.
My database contains two fields longitude and latitude.But i do not understand how to use this " include nearby cities" and for distance search.
I want to use something like Streetmap.co.uk's ActiveX Component on a website so that a visitor can enter a startpoint and destination and I can calculate the distance by road between those 2 points.
This is for a website I'm writing for a mate of mine who owns a Courier firm. He wants to be able to provide online quotes to potential customers. I'm going to be using Brinkster as the webhost so I won't be able to install any Server-side DLL's, etc. Is there anything available to do this?
I am trying to find a software that can find distance between two ZIP codes. I think most of them do it by having the longtitude and latidute of each ZIP, and substract. But this gives the air distance. Where can I find software that find the ground distance (like in Mapquest).
View Replies View RelatedI am looking for a way create a distance calculator from city to city, zip to zip, so on so forth. I know this has been done many times. Does anyone have this around by any chance. Also does anyone know of a place I can get the db or text file I need for this? I know there are some floating about but haven't came across a decent one yet.
View Replies View RelatedI have a site and i have a text box for someone to type in a zip code. i nee dto know how to program, or locate a database, where the results will display my business location(s) by zipcode and display the total distance between the zip code entered by the visitor to the site, and my locations.
like Midas has on their site (www.midas.com) where you type in a zip code and it returns the store locations and how far away they are from you.
anyone knows what the formula is for finding a distance betweeen 2 zip codes?
View Replies View RelatedI have a database having, US zipcodes, longitude and latitude. What I want to do is LIST THOSE ZIPCODES which are at a distance of given miles from a particular zip code.
For Exmaple: I want to find the zip codes which are at a distance of 15 miles from zipcode 10001 (NYC).
I have the script that uses Zipcodes, latitudes and longitudes of two cities and caculate the distance. But it calculates distance.
Any recommendations for a freeware zip code distance program? I need the client to be able to select all clients living within a certain distance of his or her zip.
View Replies View RelatedIs it possible to have some sort of hyperlink or long distance odbc connection so that I can get pages on my server here to draw from a database that is at a different location? How would this be done?
View Replies View RelatedAlright, in regards to my previous post of finding a DB that has all of the latitude/longitudes in a DB, I need to now filter through those based on search criteria. The search criteria available includes: Code:
View Replies View RelatedI know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.
View Replies View RelatedI have the following code that I am trying to use to calculate distance. However I keep getting a Type Mismatch error on line 50 which is in bold. Code:
View Replies View RelatedHow to prevent duplicate values when using BULK INSERT to insert CSV to SQL Server? Code:
View Replies View RelatedI want to be able to send two sql tables to access db at the same time
View Replies View RelatedI have a database that has 2 tables linked into it from another database. I am having problems trying to pull in values from those 2 linked databases. One of the tables is tblClient. Code:
View Replies View RelatedI need some help with a SQL statement. I currently have which works:
strSQL = "SELECT * FROM mstJobs WHERE JobStatus = True"
I need to query against a second table but I am not sure of the
correct syntax of the statement for adding another table.. somthing
like this i would imagine... ????
strSQL = "SELECT * FROM mstJobs.pmdata WHERE JobStatus = True AND
WHERE WeekEnding IN tblSuperInput.pmdata = strThursday"
Does anyone have some sample code on how to get all tables names in a MS Access database?
View Replies View RelatedI have a form in my HTML page and I require a number of checkboxes. These are to be dynamically generated from an Access database. The code below will work but it will only create a single row. How can I include the <TR> tag inside the loop - I'd probably want 4 cells per row
<table>
<tr>
<%
Do until rstCategories.EOF = True
Response.Write "<TD width=200>"_
& rstCategories("strCategory")_
& "<input name=chkCategory type=checkbox value=" &rstCategories("lngID")>"_
& "</TD>"
rstCategories.Movenext
Loop
%>
</tr></table>
I am trying to list data from the DB from three different tables. The first table is creditors, the second is statements and the third is payments. I don't know much about inner joins and I'm not even sure that's what I need to do. The first section on the page is detailed information about the creditor.
Below that is a section for a summary of all statements from that creditor. Below the statements section is a section for listing payments from that creditor. The 'creditors' table has a field of "credID" as well as the tables "statements" and "payments".
The "statements" table has a "StatementID" field and the "payments" table has a field of payID. What is the best way to list the statements and payments from a particular creditor?
Ithe goalposts have been moved (yet again!) and the database that was one, may have to become many, being used on subdomains of the same server sharing some information but not all from a 'global' database.The solution I initially found was to used linked tables and developing it on pws - this was perfect. I linked local databases to the external table data in the 'global' database hey presto the application ran smoothly. There was only 1 connection to each local database and I could retrieve all the information I needed from the global one. However on uploading I have no idea how to set this via asp or sql as online the path of the linked tables is what was on my local machine and I have found no way of being able to edit this or indeed know if this is possible.
View Replies View RelatedI've got three tables:
tblEvent
--------
Id (PK) | Event_Name
tblDelegate
--------
Id (PK) | Delegate_Name
tblBooking
--------
Id (PK) | Event_Id (FK) | Delegate_Id (FK)
I need to retrieve a recordset with the following information:
Booking Id | Event_Name | Delegate_Name
Can anyone see how to do a SELECT statement to do this?
I dont even know if ASP is the right language to be doing this, but what I am basically trying to complete is a way for a dropdown box to come, and depending on what they select data will go into a table. For instance, the dropdown will what type of taxpayer they are and if they select individual, the offered services will appear in the table.
View Replies View RelatedI have an application that creates online quizzes, each quiz has a results table generated by ASP on MS SQL Sever.
What I want to do is compare the SQL structure / code of the table I am about to create with the SQL structure / code of an existing table (previously created in ASP) to see if they are the same.
So how can I get the SQL structure of a table that already exists in my database into an ASP page?
I have a database with 2 tables in it.
Each table contains the fields: ID(autonumber),Title, Artist, Description, DiscNo, and TrackNo. The second of the two contains an additional field: Price.
How would I make an asp page in which a person enters DiscNo and Price into a form and the code would read all the fields of that record from table1 and then add those and the Price into table2?
I am looking for code that will go through all tables in MYSQL db and transfer records into text or excel files.