I need to pass data entered /created on the first page to the next page and populate the next pa

Hello I have a project that uses a large number of MS Data access pages created in Access 2003 and runs on MS SQL2005.

When I am on lets say my client, (first page in a series) data access page and I have completed the fields in the (DAP), I am directing my users to the next step of the registration process by means of a hyperlink to another Data access page in the same web but in a linked or sometimes different table.

I need to pass data entered /created on the first page to the next page and populate the next page with some data from the first page / table. (like staying on the client name and ID when i go to the next page)

I also need the first data access page to open and display a blank or new record. Not an existing record. I will also be looking to creata a drop down box as a record selector.

Any pointers in the right direction would be appreciated.
I am some what new to data access pages so a walk through would be nice but anything you got is welcome. Thanks Peter…

YOu will have to establish some Session management, either completly on the client (cookies) or on the Server (with a session cookie) or via URL states. Look for Session Management and you will find many directions in google.

HTH, Jens K. Suessmeyer.

http://www.sqlserver0205.de
|||Thanks I now have a lot to read, I do already have a username password script running fine i need to carry information foward like shopping cart total! this is https also so html post would be fine i am looking for some examples or walk through's I am sure the answer is right in front of me it usualy is!

I need to pass data entered /created on the first page to the next page and populate the nex

Hello I have a project that uses a large number of MS Data access pages created in Access 2003 and runs on MS SQL2005.

When I am on lets say my client, (first page in a series) data access page and I have completed the fields in the (DAP), I am directing my users to the next step of the registration process by means of a hyperlink to another Data access page in the same web but in a linked or sometimes different table.

I need to pass data entered /created on the first page to the next page and populate the next page with some data from the first page / table. (like staying on the client name and ID when i go to the next page)

I also need the first data access page to open and display a blank or new record. Not an existing record. I will also be looking to creata a drop down box as a record selector.

Any pointers in the right direction would be appreciated.
I am some what new to data access pages so a walk through would be nice but anything you got is welcome. Thanks Peter…

YOu will have to establish some Session management, either completly on the client (cookies) or on the Server (with a session cookie) or via URL states. Look for Session Management and you will find many directions in google.

HTH, Jens K. Suessmeyer.

http://www.sqlserver0205.de
|||Thanks I now have a lot to read, I do already have a username password script running fine i need to carry information foward like shopping cart total! this is https also so html post would be fine i am looking for some examples or walk through's I am sure the answer is right in front of me it usualy is!

I need to know the data changes in some table on a row level

Hello Guys
I have a table, contains some fileds
When update statment runs, I need to know which columns has been changed and to know the old and the new data for each row

simply i need to do the following in a trigger:

For each row ROW in tbl_Table
for each col COL in ROW
Save COL.oldValue and COL.newValue

I don't know how to do it by cursors and I don't want to use Cursors
If any one can help or provide a good advice, please help

Thanks and have a great day

Hi

It is very simply.

From Books Online:

"DML trigger statements use two special tables: the deleted table and the inserted tables. SQL Server 2005 automatically creates and manages these tables. You can use these temporary, memory-resident tables to test the effects of certain data modifications and to set conditions for DML trigger actions."

More , look for "inserted tables" in Books Online

Gigi,

www.sqlserver.ro

|||The client has SQL Server 2000 installed and don't want to upgrade to SQL Server 2005|||

On the triggers use the following statements

Insert Into SomeLogTable Select Deleted.*,'Old Value' RowStatus From Deleted

Insert Into SomeLogTable Select Inserted.*,'New Value' RowStatus From Inserted

|||In addition to Mani, you should use the full qualified names rather than *. Be aware that triggers are executed for each DML statement not per row, the trigger is even fired if no row is affected:

UPDATE SomeTable SET SomeCol = 1 WHERE 1 =2 --Will fire the trigger

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

The concepts (the deleted table and the inserted table) was in SQL 2000 too.

Gigi Ciubuc

www.sqlserver.ro

I need to know the data changes in some table on a row level

Hello Guys
I have a table, contains some fileds
When update statment runs, I need to know which columns has been changed and to know the old and the new data for each row

simply i need to do the following in a trigger:

For each row ROW in tbl_Table
for each col COL in ROW
Save COL.oldValue and COL.newValue

I don't know how to do it by cursors and I don't want to use Cursors
If any one can help or provide a good advice, please help

Thanks and have a great day

Hi

It is very simply.

From Books Online:

"DML trigger statements use two special tables: the deleted table and the inserted tables. SQL Server 2005 automatically creates and manages these tables. You can use these temporary, memory-resident tables to test the effects of certain data modifications and to set conditions for DML trigger actions."

More , look for "inserted tables" in Books Online

Gigi,

www.sqlserver.ro

|||The client has SQL Server 2000 installed and don't want to upgrade to SQL Server 2005|||

On the triggers use the following statements

Insert Into SomeLogTable Select Deleted.*,'Old Value' RowStatus From Deleted

Insert Into SomeLogTable Select Inserted.*,'New Value' RowStatus From Inserted

|||In addition to Mani, you should use the full qualified names rather than *. Be aware that triggers are executed for each DML statement not per row, the trigger is even fired if no row is affected:

UPDATE SomeTable SET SomeCol = 1 WHERE 1 =2 --Will fire the trigger

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

The concepts (the deleted table and the inserted table) was in SQL 2000 too.

Gigi Ciubuc

www.sqlserver.ro

i need to find a table in my DB how to do it will QA

i have a app that runs on sql. i need to fine a table in it to make
changes. the table should have a field in it call translations patterns"
in it. what the cmds for QA do i use and what else do i need to do to see
whats this table tide to. Please help
James Grace
System Engineer /Professional Srvc.
MCSE MCSA MCDBA CCNA CCNP CQS
You could use the Object Search feature in Query Analyzer. Just open QA, hit
F4 to oben Object Search, type the column name into the Object Name textbox
and select Column checkbox and hit Find Now.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"AA" <jgrace@.digitelusa.net> wrote in message
news:eKg1tz2VFHA.3540@.TK2MSFTNGP15.phx.gbl...
>i have a app that runs on sql. i need to fine a table in it to make
>changes. the table should have a field in it call translations patterns"
>in it. what the cmds for QA do i use and what else do i need to do to see
>whats this table tide to. Please help
> --
> James Grace
> System Engineer /Professional Srvc.
> MCSE MCSA MCDBA CCNA CCNP CQS
>
>
|||Hi,
You could also do a search in INFORMATION_SCHEMA.columns view.
SELECT COLUMN_NAME,TABLE_NAME
FROM INFORMATION_SCHEMA.columns
WHERE COLUMN_NAME like 'translations%'
You could also query syscolumns system table (Not recommended)
Thanks
Hari
SQL Server MVP
"AA" <jgrace@.digitelusa.net> wrote in message
news:eKg1tz2VFHA.3540@.TK2MSFTNGP15.phx.gbl...
>i have a app that runs on sql. i need to fine a table in it to make
>changes. the table should have a field in it call translations patterns"
>in it. what the cmds for QA do i use and what else do i need to do to see
>whats this table tide to. Please help
> --
> James Grace
> System Engineer /Professional Srvc.
> MCSE MCSA MCDBA CCNA CCNP CQS
>
>
|||Try AgileInfoSoftware's DataStudio, it has very powerful search features.
Evaluation is free and can be downloaded at http://www.AgileInfoLLC.com
John
Senior Support Engineer
MCSD, MCSD.NET, SCJP, SCJD, OCDBA
"AA" <jgrace@.digitelusa.net> wrote in message
news:eKg1tz2VFHA.3540@.TK2MSFTNGP15.phx.gbl...
>i have a app that runs on sql. i need to fine a table in it to make
>changes. the table should have a field in it call translations patterns"
>in it. what the cmds for QA do i use and what else do i need to do to see
>whats this table tide to. Please help
> --
> James Grace
> System Engineer /Professional Srvc.
> MCSE MCSA MCDBA CCNA CCNP CQS
>
>

I need Help Urgent

Hi all!

I have an Application thats runs on my network Peoples have to Update their Client Apps to the newst version.

Most of Users are not well aware of computers.

I have a sinario to update the Client Application details bellow:

Provide a link e.g. Http://www.myserver.com/updates.aspx?action=getupdates

I want the client click the Link and my asp.net Page do the following

1- Compare the version of the Application on local machine With App.exe on server

2- Tell User if he / she needs Updates

3- Proceed according to the users Desion

Download without prompting the User

Install Update

Exit the web browser or redirct

Please Help me if any one have some directions or Working Examples.

Happy Coding

//////// Rashed

Look at the ClickOnce technology, it brings all the stuff out-of-the-box.

Jens K. Suessmeyer

http://www.sqlserver2005.de