Inserting value into database based on other fields

[Mintyman]

Hi,

I have 3 fields in a form: CATEGORY, NUMBER and YEAR. In addition to
inserting these 3 fields into a database table, I would like to insert a 4th
one which is a combination of all three fields, with each field seperated by
a hyphen E.g.

CATEGORY-NUMBER-YEAR

or

31-01-05

I need this 4th field to be inserted as SERIAL_NO

I know how to use the insert record behaviour but that only picks up the 3
designated fields. I don't know how to A) create the fourth from the
combination of the previous 3 and B) insert it into the table
'PRODUCT_DESCRIPTION'

Can anyone help?

[Paul Whitham TMM]

How easy this is depends upon the server model being used. If you are usign
ASP the DW generated coded is pretty hard to decipher, in which case I would
recommend that you manually write an insert statement.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Mintyman" <mintyman@ntlworld.com> wrote in message
news:d0jsoc$egm$1@forums.macromedia.com...

> Hi,
>
> I have 3 fields in a form: CATEGORY, NUMBER and YEAR. In addition to
> inserting these 3 fields into a database table, I would like to insert a

4th

> one which is a combination of all three fields, with each field seperated

by

> a hyphen E.g.
>
> CATEGORY-NUMBER-YEAR
>
> or
>
> 31-01-05
>
> I need this 4th field to be inserted as SERIAL_NO
>
> I know how to use the insert record behaviour but that only picks up the 3
> designated fields. I don't know how to A) create the fourth from the
> combination of the previous 3 and B) insert it into the table
> 'PRODUCT_DESCRIPTION'
>
> Can anyone help?
>
>

[Mintyman]

its ASP with VBScript im using. Does help you find a solution for me?


"Paul Whitham TMM" <paul@valleybiz.net> wrote in message
news:d0l8nb$mki$1@forums.macromedia.com...

> How easy this is depends upon the server model being used. If you are

usign

> ASP the DW generated coded is pretty hard to decipher, in which case I

would

> recommend that you manually write an insert statement.
>
> --
> Regards
>
> Paul Whitham
> Macromedia Certified Professional for Dreamweaver MX2004
> Valleybiz Internet Design
> [url]www.valleybiz.net[/url]
>
> Team Macromedia Volunteer for Ultradev/Dreamweaver MX
> [url]www.macromedia.com/support/forums/team_macromedia[/url]
>
> "Mintyman" <mintyman@ntlworld.com> wrote in message
> news:d0jsoc$egm$1@forums.macromedia.com...

> > Hi,
> >
> > I have 3 fields in a form: CATEGORY, NUMBER and YEAR. In addition to
> > inserting these 3 fields into a database table, I would like to insert a

> 4th

> > one which is a combination of all three fields, with each field

seperated

> by

> > a hyphen E.g.
> >
> > CATEGORY-NUMBER-YEAR
> >
> > or
> >
> > 31-01-05
> >
> > I need this 4th field to be inserted as SERIAL_NO
> >
> > I know how to use the insert record behaviour but that only picks up the

3

> > designated fields. I don't know how to A) create the fourth from the
> > combination of the previous 3 and B) insert it into the table
> > 'PRODUCT_DESCRIPTION'
> >
> > Can anyone help?
> >
> >

>
>

[Paul Whitham TMM]

This is a hand coded ASP Insert statement

<%
dim strConn
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("/_database/Conf2005.mdb")
dim strTitle
dim strContent
strTitle = Request.Form("txtTitle")
strContent = Request.Form("txtContent")

dim adoCn
dim strSQL
set adoCn = Server.CreateObject("ADODB.Connection")
adoCn.Open strConn
strSQL = "Insert Into TblPageContent (PageName, Introtext) Values ('" &
replace(strTitle,"'","''") & "','" & replace(strContent,"'","''") & "')"
adoCn.Execute strSQL
adoCn.Close
set adoCn = nothing
%>

To create a variable that would add fields together you would do something
like this

Dim strSerial
strSerial = Request.Form("CATEGORY") & "-" & Request.Form("NUMBER") & "-" &
Request.Form("YEAR")

and then add it to the insert line.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Mintyman" <mintyman@ntlworld.com> wrote in message
news:d0n2eq$gjq$1@forums.macromedia.com...

> its ASP with VBScript im using. Does help you find a solution for me?
>
>
> "Paul Whitham TMM" <paul@valleybiz.net> wrote in message
> news:d0l8nb$mki$1@forums.macromedia.com...

> > How easy this is depends upon the server model being used. If you are

> usign

> > ASP the DW generated coded is pretty hard to decipher, in which case I

> would

> > recommend that you manually write an insert statement.
> >
> > --
> > Regards
> >
> > Paul Whitham
> > Macromedia Certified Professional for Dreamweaver MX2004
> > Valleybiz Internet Design
> > [url]www.valleybiz.net[/url]
> >
> > Team Macromedia Volunteer for Ultradev/Dreamweaver MX
> > [url]www.macromedia.com/support/forums/team_macromedia[/url]
> >
> > "Mintyman" <mintyman@ntlworld.com> wrote in message
> > news:d0jsoc$egm$1@forums.macromedia.com...

> > > Hi,
> > >
> > > I have 3 fields in a form: CATEGORY, NUMBER and YEAR. In addition to
> > > inserting these 3 fields into a database table, I would like to insert

a

> > 4th

> > > one which is a combination of all three fields, with each field

> seperated

> > by

> > > a hyphen E.g.
> > >
> > > CATEGORY-NUMBER-YEAR
> > >
> > > or
> > >
> > > 31-01-05
> > >
> > > I need this 4th field to be inserted as SERIAL_NO
> > >
> > > I know how to use the insert record behaviour but that only picks up

the

> 3

> > > designated fields. I don't know how to A) create the fourth from the
> > > combination of the previous 3 and B) insert it into the table
> > > 'PRODUCT_DESCRIPTION'
> > >
> > > Can anyone help?
> > >
> > >

> >
> >

>
>