Merge Columns via ASP !!!

[Anthony Judd]

Is their a way using JET sql i can merge two columns in an Access DB via my
asp script.
Any insight or links to some good info would be appreciated!!!!

[Jeff Cochran]

On Wed, 16 Jul 2003 03:14:42 +1000, "Anthony Judd" <adsf@.com> wrote:

>Is their a way using JET sql i can merge two columns in an Access DB via my
>asp script.
>Any insight or links to some good info would be appreciated!!!!

Start with the first part -- Is there any way using JET SQL to merge
two columns?

Then you'll need to define "merge" in database terms. Do you want to
only transfer the first field if the second is null? Which one wins
if they are both non-null? Or do you want to concatenate the data, as
in taking the FirstName and LastName column and making a Name column?
Or do you just want to return both fields in a query, but leave the
actual database alone?

The basic answer is "Yes you can do it" but the real answer is you
need to do more than just MERGE Column1, Column2 as a set of SQL
statements. Once you have the SQL and data transformation rules
figured out, the ASP is the easy part.

Jeff
===================================
Jeff Cochran (IIS MVP)
[email]jcochran.nospam@naplesgov.com[/email] - Munged of Course

I don't get much time to respond to direct email,
so posts here will have a better chance of getting
an answer. Besides, everyone benefits here.

Suggested resources:
[url]http://www.iisfaq.com/[/url]
[url]http://www.iisanswers.com/[/url]
[url]http://www.iistoolshed.com/[/url]
[url]http://securityadmin.info/[/url]
[url]http://www.aspfaq.com/[/url]
[url]http://support.microsoft.com/[/url]
====================================

[Anthony Judd]

I want to concatenate the two database collumns..
Any one have any suggestion about how to do this using jet sql..

thanx !!!

[Bob Barrows]

Anthony Judd wrote:

> I want to concatenate the two database collumns..
> Any one have any suggestion about how to do this using jet sql..
>
> thanx !!!

What do you want to do? Create a new column in the table? Overwrite the data
in one of the columns with the concatenated data? Return the result to the
user without modifying the table?

Concatenation is merely this:

[column1] & [column2]

HTH,
Bob Barrows

[Jeff Cochran]

On Thu, 17 Jul 2003 19:48:18 +1000, "Anthony Judd" <adsf@.com> wrote:

>I want to concatenate the two database collumns..
>Any one have any suggestion about how to do this using jet sql..

A permanent change? To a new column name, or one of the originals?

Assuming two columns being combined into one permanently, it would be
pretty dumb to do this in ASP anyway since it's a one shot deal. If
you really must, then it would run something like this (Pseudocode):

Create the new column

Open the database
Recordset = SELECT * from Table
For each record in recordset
NewField = Oldfield1 & Oldfield2
UPDATE table with NewField
Next

Delete the two original columns

Jeff

[Bob Barrows]

Jeff Cochran wrote:

> Open the database
> Recordset = SELECT * from Table
> For each record in recordset
> NewField = Oldfield1 & Oldfield2
> UPDATE table with NewField
> Next
>
> Delete the two original columns
>

Why use a recordset?

Update table set newfield = oldfield1 & oldfield2

Bob Barrows

[Anthony Judd]

Thanx Bob...worked beautifully.


"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:edxOxYGTDHA.1556@TK2MSFTNGP10.phx.gbl...

> Jeff Cochran wrote:

> > Open the database
> > Recordset = SELECT * from Table
> > For each record in recordset
> > NewField = Oldfield1 & Oldfield2
> > UPDATE table with NewField
> > Next
> >
> > Delete the two original columns
> >

> Why use a recordset?
>
> Update table set newfield = oldfield1 & oldfield2
>
> Bob Barrows
>
>