FIle Form Element

am 12.05.2007 12:47:01 von rn5a

I am storing the physical path of images, along with 3 more columns,
in a MS-Access DB table. I want to provide users the option to change
this physical image path (as well as the records in the other columns)
for which I am using the *File* Form element.

The column under which the physical paths are stored is the 4th column
in the DB table.

Users first come to a page that displays the distinct records existing
in column1 in the above mentioned DB table in a dropdown select list.
When an option is selected by the user & the Form is posted, the next
page would retrieve the records from the DB table depending upon what
a user selected from the dropdown select list & display them to the
user in textboxes so that they can edit the records.

<%
Dim objConn
Set objConn=Server.CreateObject("ADODB.CONNECTION")
'ConnectionString
objConn.Open

Dim strSQL
strSQL="SELECT * FROM MyTable WHERE Col1='" &
Request.Form("selectlistvalue") & "'"

Dim objRS
Set objRS=Server.CreateObject("ADODB.RECORDSET")
objRS.Open strSQL,objConn
%>

The problem is, unlike the textboxes, the *File* Form field doesn't
display the physical path (Col4) in the textbox that accompanies the
*File* Form element.

Any idea how do I make the textbox in the *File* Form field show the
record from Col4 (i.e. the physical path) from the DB table like how
the other 3 textboxes display their respective records?

Re: FIle Form Element

am 12.05.2007 13:37:02 von reb01501

rn5a@rediffmail.com wrote:
> I am storing the physical path of images, along with 3 more columns,
> in a MS-Access DB table. I want to provide users the option to change
> this physical image path (as well as the records in the other columns)
> for which I am using the *File* Form element.

Not possible. You need to use a textbox..

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: FIle Form Element

am 12.05.2007 13:37:33 von rn5a

On May 12, 3:47 pm, r...@rediffmail.com wrote:
> I am storing the physical path of images, along with 3 more columns,
> in a MS-Access DB table. I want to provide users the option to change
> this physical image path (as well as the records in the other columns)
> for which I am using the *File* Form element.
>
> The column under which the physical paths are stored is the 4th column
> in the DB table.
>
> Users first come to a page that displays the distinct records existing
> in column1 in the above mentioned DB table in a dropdown select list.
> When an option is selected by the user & the Form is posted, the next
> page would retrieve the records from the DB table depending upon what
> a user selected from the dropdown select list & display them to the
> user in textboxes so that they can edit the records.
>
> <%
> Dim objConn
> Set objConn=Server.CreateObject("ADODB.CONNECTION")
> 'ConnectionString
> objConn.Open
>
> Dim strSQL
> strSQL="SELECT * FROM MyTable WHERE Col1='" &
> Request.Form("selectlistvalue") & "'"
>
> Dim objRS
> Set objRS=Server.CreateObject("ADODB.RECORDSET")
> objRS.Open strSQL,objConn
> %>
>

>
> The problem is, unlike the textboxes, the *File* Form field doesn't
> display the physical path (Col4) in the textbox that accompanies the
> *File* Form element.
>
> Any idea how do I make the textbox in the *File* Form field show the
> record from Col4 (i.e. the physical path) from the DB table like how
> the other 3 textboxes display their respective records?

ADDENDUM:
-------------

The same thing happens if a textbox field is replaced with a textarea
Form element. For e.g. using the following code

"></<br />
textarea><br />
<br />
the textarea remains blank!</p>
</article>
<article>
<h2>Re: FIle Form Element</h2><span>am 12.05.2007 14:49:16 von exjxw.hannivoort</span>
<p>wrote on 12 mei 2007 in microsoft.public.inetserver.asp.general:<br />
<br />
> <input type=file name="col4" value="<%= objRS("Col4") %>"><br />
> </form><br />
> <br />
> The problem is, unlike the textboxes, the *File* Form field doesn't<br />
> display the physical path (Col4) in the textbox that accompanies the<br />
> *File* Form element.<br />
<br />
Since the files and the directory layout on my, the client's, machine is <br />
non of your, the server's and the programmer's, business, the powers that <br />
make browsers have rightly thought it fitting that the security regime <br />
prohibits  your intent.<br />
<br />
Furthermore this is not an ASP serverside problem, <br />
so your quest is off-topic on this NG.<br />
<br />
If you want to further your doomed quest, <br />
please do so elsewhere, not on a serverside code NG,<br />
as serverside code like under ASP doesn't know about <br />
<input type='file'>.<br />
<br />
-- <br />
Evertjan.<br />
The Netherlands.<br />
(Please change the x'es to dots in my emailaddress)</p>
</article>
<article>
<h2>Re: FIle Form Element</h2><span>am 14.05.2007 16:28:33 von Justin Piper</span>
<p>On Sat, 12 May 2007 06:37:33 -0500, <rn5a@rediffmail.com> wrote:<br />
<br />
> On May 12, 3:47 pm, r...@rediffmail.com wrote:<br />
><br />
> The same thing happens if a textbox field is replaced with a textarea<br />
> Form element. For e.g. using the following code<br />
><br />
> <textarea name=3D"col2" col=3D20 rows=3D10 value=3D"<%=3D objRS("Col2"=<br />
) %>"></<br />
> textarea><br />
><br />
> the textarea remains blank!<br />
><br />
<br />
The textarea element does not have a value attribute. Instead you nest i=<br />
ts  =<br />
<br />
content inside the element:<br />
<br />
    <textarea name=3D"col2" cols=3D"20" rows=3D"10"><%=3D objRS("Col2") =<br />
 =<br />
<br />
%>

You can find documentation for the textarea element as well as other HTM=
L =

elemnts on Microsoft's website:

textArea Object
http://msdn2.microsoft.com/en-us/library/ms535904.aspx

HTML Elements
http://msdn2.microsoft.com/en-us/library/ms533029.aspx

-- =

Justin Piper
Bizco Technologies
http://www.bizco.com/