473,327 Members | 2,090 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Inserting values into a table

Hi there,

I am new to ASP and i have really only been exposed to getting data from a
SQL database and displaying it.

I want to include a page in my application (like a form in Access i guess)
with various text boxes and drop-downs + tick boxes.
Then i want to click a submit button that inserts the data (providing is
valid) into a SQL Server table.

I have had a search in google but nothing seems to explain this in its most
basic terms (errorchecking and inserting).

Could anyone give me an example of this or some background about this
functionality.

Thanks

--
Thanks in advance

Fawke

Please remove ANTI and SPAM
from my email address before emailing me.

www.bradflack.com
Jul 19 '05 #1
5 1388
www.w3schools.com / learning ASP
Jul 19 '05 #2
On Fri, 2 Apr 2004 10:50:35 +0100, "Fawke101"
<gu*@ANTIbradflack.SPAMcom> wrote:
I am new to ASP and i have really only been exposed to getting data from a
SQL database and displaying it.

I want to include a page in my application (like a form in Access i guess)
with various text boxes and drop-downs + tick boxes.
Then i want to click a submit button that inserts the data (providing is
valid) into a SQL Server table.

I have had a search in google but nothing seems to explain this in its most
basic terms (errorchecking and inserting).

Could anyone give me an example of this or some background about this
functionality.


You need a better Google search then... )

Start with a basic ASP database tutorial and a SQL tutorial. For the
latter, use sqlcourse.com. For the former, Google "asp database
tutorial" and start reading. When you have that down, start
researching input error checking.

You may also need some HTML tutorials if you don't understand forms.

Jeff
Jul 19 '05 #3
Sorry,

I know my way around in HTML and ASP to a certain extent.
Its just that i have never been in the situation to use INSERT statements. I
didnt know what was/was not good practise and how exactly the INSERT worked.
I am not a complete novice, just new to this function.

Thanks anyhow, il have a look around

--
Thanks in advance

Fawke

Please remove ANTI and SPAM
from my email address before emailing me.

www.bradflack.com
"Jeff Cochran" <jc*************@naplesgov.com> wrote in message
news:40***************@msnews.microsoft.com...
On Fri, 2 Apr 2004 10:50:35 +0100, "Fawke101"
<gu*@ANTIbradflack.SPAMcom> wrote:
I am new to ASP and i have really only been exposed to getting data from aSQL database and displaying it.

I want to include a page in my application (like a form in Access i guess)with various text boxes and drop-downs + tick boxes.
Then i want to click a submit button that inserts the data (providing is
valid) into a SQL Server table.

I have had a search in google but nothing seems to explain this in its mostbasic terms (errorchecking and inserting).

Could anyone give me an example of this or some background about this
functionality.


You need a better Google search then... )

Start with a basic ASP database tutorial and a SQL tutorial. For the
latter, use sqlcourse.com. For the former, Google "asp database
tutorial" and start reading. When you have that down, start
researching input error checking.

You may also need some HTML tutorials if you don't understand forms.

Jeff

Jul 19 '05 #4
You should be able to find the syntax for Update and Insert in the searches
Jeff mentioned. Just remember that Insert is for adding entire "new"
records, while Update is to alter existing data.
--

Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com
"Fawke101" <gu*@ANTIbradflack.SPAMcom> wrote in message
news:#c**************@TK2MSFTNGP10.phx.gbl...
Sorry,

I know my way around in HTML and ASP to a certain extent.
Its just that i have never been in the situation to use INSERT statements. I didnt know what was/was not good practise and how exactly the INSERT worked. I am not a complete novice, just new to this function.

Thanks anyhow, il have a look around

--
Thanks in advance

Fawke

Please remove ANTI and SPAM
from my email address before emailing me.

www.bradflack.com
"Jeff Cochran" <jc*************@naplesgov.com> wrote in message
news:40***************@msnews.microsoft.com...
On Fri, 2 Apr 2004 10:50:35 +0100, "Fawke101"
<gu*@ANTIbradflack.SPAMcom> wrote:
I am new to ASP and i have really only been exposed to getting data from
a
SQL database and displaying it.

I want to include a page in my application (like a form in Access i guess)with various text boxes and drop-downs + tick boxes.
Then i want to click a submit button that inserts the data (providing
isvalid) into a SQL Server table.

I have had a search in google but nothing seems to explain this in its

mostbasic terms (errorchecking and inserting).

Could anyone give me an example of this or some background about this
functionality.


You need a better Google search then... )

Start with a basic ASP database tutorial and a SQL tutorial. For the
latter, use sqlcourse.com. For the former, Google "asp database
tutorial" and start reading. When you have that down, start
researching input error checking.

You may also need some HTML tutorials if you don't understand forms.

Jeff


Jul 19 '05 #5
On Fri, 2 Apr 2004 12:54:38 -0600, "Phillip Windell" <@.> wrote:
You should be able to find the syntax for Update and Insert in the searches
Jeff mentioned. Just remember that Insert is for adding entire "new"
records, while Update is to alter existing data.


And one solution to that is to do an IF EXISTS on the record to choose
whether to use an INSERT or UPDATE query. Books Online will give you
the syntax if you decide to look in that direction, as well as syntax
for the queries. The sqlcourse.com site covers each type of query
very concisely and is easy to understand.

Jeff
Jul 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Marko Poutiainen | last post by:
Situation: We had to make our SQLServer 2000 database multi-lingual. That is, certain things (such as product names) in the database should be shown in the language the user is using (Finnish,...
1
by: bockley | last post by:
I am having trouble inserting two queries...I am trying to insert an new item(pk) into a table in one query, and then inserting an item(fk) in another table that relates to the other item just...
2
by: Charles Wilt | last post by:
I have a IBM iSeries (aka AS-400) running v5r3 of OS/400 that I access via a linked server from SQL Server 2000. The following select works fine: select * from...
1
by: ing42 | last post by:
I have a problem with inserting records into table when an indexed view is based on it. Table has text field (without it there is no problem, but I need it). Here is a sample code: USE test GO...
15
by: Jaraba | last post by:
I am working in a project that I need to parse an arrayt an select records based upon the values parsed. I used the functions developed by Knut Stolze in his article 'Parsing Strings'. I am...
4
by: FangQ | last post by:
hi I am very new to mysql. I have a question about using the "on duplicate update" clause with insert command. my table "data" has two columns, field1 and field2, where field1 is the index...
4
by: Manikandan | last post by:
Hi, I'm inserting a datetime values into sql server 2000 from c# SQL server table details Table name:date_test columnname datatype No int date_t DateTime ...
0
by: toyin | last post by:
hello, pls help look through this code its not inserting the record in dataset into the another database. i want to insert the row in the dataset into another table in another database. pls help....
2
by: Eraser | last post by:
Hello, I'm just starting to learn PL/SQL. To get my feet wet, I'm trying to write a simple stored procedure that takes some values as parameters, and inserts those values into a table. For...
2
by: AlexanderDeLarge | last post by:
Hi! I got a problem that's driving me crazy and I'm desperately in need of help. I'll explain my scenario: I'm doing a database driven site for a band, I got these tables for their discography...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.