I have a form which the user uses to enter data which is saved into an SQL
Server database.

I need them to be able to upload an image as well and to have it saved in
the same or a differant table.

How do I do this?

--
Jonathan Blitz
AnyKey Limited
Israel

Tel: (972) 8 9790365

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."

Re: Upload image into SQL Server database by Kevin

Kevin
Tue Nov 16 14:08:36 CST 2004

Your best bet is to store the image in your file system, and the name or
path to the image in the database. Storing images in databases is both
tricky and bad for performance, and should be avoided when possible.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in message
news:eGb2iOBzEHA.3548@TK2MSFTNGP09.phx.gbl...
> I have a form which the user uses to enter data which is saved into an SQL
> Server database.
>
> I need them to be able to upload an image as well and to have it saved in
> the same or a differant table.
>
> How do I do this?
>
> --
> Jonathan Blitz
> AnyKey Limited
> Israel
>
> Tel: (972) 8 9790365
>
> "When things seem bad
> Don't worry and shout
> Just count up the times
> Things have worked themselves out."
>
>



Re: Upload image into SQL Server database by Jonathan

Jonathan
Tue Nov 16 14:22:13 CST 2004

How do I build the form so that includes both an insert into an SQL Server
table and an upload?
Laso, how will I get the file name so as to insert it into the file?

--
Jonathan Blitz
AnyKey Limited
Israel

Tel: (972) 8 9790365

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
"Kevin Spencer" <kspencer@takempis.com> wrote in message
news:%23SJoQgBzEHA.4004@tk2msftngp13.phx.gbl...
> Your best bet is to store the image in your file system, and the name or
> path to the image in the database. Storing images in databases is both
> tricky and bad for performance, and should be avoided when possible.
>
> --
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> Neither a follower
> nor a lender be.
>
> "Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in message
> news:eGb2iOBzEHA.3548@TK2MSFTNGP09.phx.gbl...
> > I have a form which the user uses to enter data which is saved into an
SQL
> > Server database.
> >
> > I need them to be able to upload an image as well and to have it saved
in
> > the same or a differant table.
> >
> > How do I do this?
> >
> > --
> > Jonathan Blitz
> > AnyKey Limited
> > Israel
> >
> > Tel: (972) 8 9790365
> >
> > "When things seem bad
> > Don't worry and shout
> > Just count up the times
> > Things have worked themselves out."
> >
> >
>
>



Re: Upload image into SQL Server database by Kevin

Kevin
Tue Nov 16 16:16:13 CST 2004

Well, you're talking about a custom web application. You would have to know
ASP, ASP.Net or some other server-side programming technology to do it.

FrontPage comes with some fairly common types of forms. You can build a data
entry form that inserts data into a database. You can create a form with
FrontPage 2003 that can upload a file. But I don't believe you can combine
the 2 without your own code.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in message
news:eVPuqJCzEHA.1564@TK2MSFTNGP09.phx.gbl...
> How do I build the form so that includes both an insert into an SQL Server
> table and an upload?
> Laso, how will I get the file name so as to insert it into the file?
>
> --
> Jonathan Blitz
> AnyKey Limited
> Israel
>
> Tel: (972) 8 9790365
>
> "When things seem bad
> Don't worry and shout
> Just count up the times
> Things have worked themselves out."
> "Kevin Spencer" <kspencer@takempis.com> wrote in message
> news:%23SJoQgBzEHA.4004@tk2msftngp13.phx.gbl...
> > Your best bet is to store the image in your file system, and the name or
> > path to the image in the database. Storing images in databases is both
> > tricky and bad for performance, and should be avoided when possible.
> >
> > --
> > HTH,
> > Kevin Spencer
> > .Net Developer
> > Microsoft MVP
> > Neither a follower
> > nor a lender be.
> >
> > "Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in
message
> > news:eGb2iOBzEHA.3548@TK2MSFTNGP09.phx.gbl...
> > > I have a form which the user uses to enter data which is saved into an
> SQL
> > > Server database.
> > >
> > > I need them to be able to upload an image as well and to have it saved
> in
> > > the same or a differant table.
> > >
> > > How do I do this?
> > >
> > > --
> > > Jonathan Blitz
> > > AnyKey Limited
> > > Israel
> > >
> > > Tel: (972) 8 9790365
> > >
> > > "When things seem bad
> > > Don't worry and shout
> > > Just count up the times
> > > Things have worked themselves out."
> > >
> > >
> >
> >
>
>



Re: Upload image into SQL Server database by Jonathan

Jonathan
Tue Nov 16 15:30:04 CST 2004

I know ASP.
What I can't see is how I combine the input form with the image load form.
Can I just put the webbots created under one form and use the one submit
button?


--
Jonathan Blitz
AnyKey Limited
Israel

Tel: (972) 8 9790365

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
"Kevin Spencer" <kspencer@takempis.com> wrote in message
news:uw3kmnCzEHA.1596@TK2MSFTNGP10.phx.gbl...
> Well, you're talking about a custom web application. You would have to
know
> ASP, ASP.Net or some other server-side programming technology to do it.
>
> FrontPage comes with some fairly common types of forms. You can build a
data
> entry form that inserts data into a database. You can create a form with
> FrontPage 2003 that can upload a file. But I don't believe you can combine
> the 2 without your own code.
>
> --
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> Neither a follower
> nor a lender be.
>
> "Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in message
> news:eVPuqJCzEHA.1564@TK2MSFTNGP09.phx.gbl...
> > How do I build the form so that includes both an insert into an SQL
Server
> > table and an upload?
> > Laso, how will I get the file name so as to insert it into the file?
> >
> > --
> > Jonathan Blitz
> > AnyKey Limited
> > Israel
> >
> > Tel: (972) 8 9790365
> >
> > "When things seem bad
> > Don't worry and shout
> > Just count up the times
> > Things have worked themselves out."
> > "Kevin Spencer" <kspencer@takempis.com> wrote in message
> > news:%23SJoQgBzEHA.4004@tk2msftngp13.phx.gbl...
> > > Your best bet is to store the image in your file system, and the name
or
> > > path to the image in the database. Storing images in databases is both
> > > tricky and bad for performance, and should be avoided when possible.
> > >
> > > --
> > > HTH,
> > > Kevin Spencer
> > > .Net Developer
> > > Microsoft MVP
> > > Neither a follower
> > > nor a lender be.
> > >
> > > "Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in
> message
> > > news:eGb2iOBzEHA.3548@TK2MSFTNGP09.phx.gbl...
> > > > I have a form which the user uses to enter data which is saved into
an
> > SQL
> > > > Server database.
> > > >
> > > > I need them to be able to upload an image as well and to have it
saved
> > in
> > > > the same or a differant table.
> > > >
> > > > How do I do this?
> > > >
> > > > --
> > > > Jonathan Blitz
> > > > AnyKey Limited
> > > > Israel
> > > >
> > > > Tel: (972) 8 9790365
> > > >
> > > > "When things seem bad
> > > > Don't worry and shout
> > > > Just count up the times
> > > > Things have worked themselves out."
> > > >
> > > >
> > >
> > >
> >
> >
>
>



Re: Upload image into SQL Server database by Stefan

Stefan
Wed Nov 17 02:55:47 CST 2004

See http://support.microsoft.com/default.aspx?scid=kb;en-us;288328

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in message news:uCw8kvCzEHA.2540@TK2MSFTNGP09.phx.gbl...
| I know ASP.
| What I can't see is how I combine the input form with the image load form.
| Can I just put the webbots created under one form and use the one submit
| button?
|
|
| --
| Jonathan Blitz
| AnyKey Limited
| Israel
|
| Tel: (972) 8 9790365
|
| "When things seem bad
| Don't worry and shout
| Just count up the times
| Things have worked themselves out."
| "Kevin Spencer" <kspencer@takempis.com> wrote in message
| news:uw3kmnCzEHA.1596@TK2MSFTNGP10.phx.gbl...
| > Well, you're talking about a custom web application. You would have to
| know
| > ASP, ASP.Net or some other server-side programming technology to do it.
| >
| > FrontPage comes with some fairly common types of forms. You can build a
| data
| > entry form that inserts data into a database. You can create a form with
| > FrontPage 2003 that can upload a file. But I don't believe you can combine
| > the 2 without your own code.
| >
| > --
| > HTH,
| > Kevin Spencer
| > .Net Developer
| > Microsoft MVP
| > Neither a follower
| > nor a lender be.
| >
| > "Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in message
| > news:eVPuqJCzEHA.1564@TK2MSFTNGP09.phx.gbl...
| > > How do I build the form so that includes both an insert into an SQL
| Server
| > > table and an upload?
| > > Laso, how will I get the file name so as to insert it into the file?
| > >
| > > --
| > > Jonathan Blitz
| > > AnyKey Limited
| > > Israel
| > >
| > > Tel: (972) 8 9790365
| > >
| > > "When things seem bad
| > > Don't worry and shout
| > > Just count up the times
| > > Things have worked themselves out."
| > > "Kevin Spencer" <kspencer@takempis.com> wrote in message
| > > news:%23SJoQgBzEHA.4004@tk2msftngp13.phx.gbl...
| > > > Your best bet is to store the image in your file system, and the name
| or
| > > > path to the image in the database. Storing images in databases is both
| > > > tricky and bad for performance, and should be avoided when possible.
| > > >
| > > > --
| > > > HTH,
| > > > Kevin Spencer
| > > > .Net Developer
| > > > Microsoft MVP
| > > > Neither a follower
| > > > nor a lender be.
| > > >
| > > > "Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in
| > message
| > > > news:eGb2iOBzEHA.3548@TK2MSFTNGP09.phx.gbl...
| > > > > I have a form which the user uses to enter data which is saved into
| an
| > > SQL
| > > > > Server database.
| > > > >
| > > > > I need them to be able to upload an image as well and to have it
| saved
| > > in
| > > > > the same or a differant table.
| > > > >
| > > > > How do I do this?
| > > > >
| > > > > --
| > > > > Jonathan Blitz
| > > > > AnyKey Limited
| > > > > Israel
| > > > >
| > > > > Tel: (972) 8 9790365
| > > > >
| > > > > "When things seem bad
| > > > > Don't worry and shout
| > > > > Just count up the times
| > > > > Things have worked themselves out."
| > > > >
| > > > >
| > > >
| > > >
| > >
| > >
| >
| >
|
|