Adding ID field to another column with data already in it.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field called image. it is hidden and automatically sends the value
"images/nowserving/image0--.gif". Where "--" needs to be the same as the ID
number. ex "images/nowserving/image010.gif". Is there anyway to do this
automatically? Currently I am manually modifing the "--" in the database to
match the ID#.
 
You could skip the process of storing the image name in the database altogether, if you will always
have a image for the record. Then to display the image on your page, do:

"images/nowserving/image<%=recordset("ID")%>.gif".

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
This may come in handy, but I dont think this will accomplish my goal. Here
is what I am doing. This site is a "help desk" type system. I have "now
serving" images that are displayed on a results page ONLY if an "x" appears
in the status column. This way, as we help each person, i can just place an x
in the record that we are helping and it will automatically display the now
serving image. The path to that image is "images/nowserving/image__.gif".
Does this make sense?
 
If you are adding a record: The problem is if you are currently using the Access Autonumber field,
you will not know the record number until after the record is written to the database.

If you are editing/updating the record: Then just make sure that the ID number is being requested in
your query, unless using * which will give it to you automatically, then you would create a hidden
form field like:

<input type="hidden" name="fieldname" value="images/nowserving/image<%=recordsetname("ID")%>.gif">

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Does recordsetname refer to "results"? i did this but it did not work.
However, i am a little unclear about the * thing.
 
Ok,

recordsetname is the name of your recordset, if use the FP database component, rename recordsetname
to:

fp_rs


* is the shortcut method of retrieving all the fields in the record, without have to specify each
fieldname.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Thomas, i appreciate your patience....you must think i am an idiot by now. I
am getting the following error on the page when I added the hidden field.

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'fp_rs'

/techhelp/tech.asp, line 283
 
Paste the code from line 283 in to a reply.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Also include a few lines above and below line 283.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Intesting, but the code on the referenced page only goes up to 200. I think
it may be refering to the "_fpclass/fpdbrgn1.inc" file...but again not sure.
The code below is from the reference page and starts on line 147-200.


<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="6079" --><tr>
<td><img src= "<!--webbot bot="DatabaseResultColumn"
s-columnnames="Status,ID,Name,Room,Email,Image,Problem,Remote_computer_name1,User_name1,Browser_type1,Timestamp1"
s-column="Image" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Image<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Image")%>"><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="8552" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
width="100%"><font color="#000000">This is the end of a Database Results
region.</font></td></tr>" startspan --><!--#include
file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>

</table>

<p> </td>
</tr>
<tr>
<td width="137" height="48">
<p align="left"><b><font face="Arial">Room#: </font></b></p>
</td>
<td height="48" width="265"><font face="Arial">
<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="1"
i-maximum-length="15" --><input type="text" name="Room" size="9"
maxlength="15" tabindex="2"></font></td>
</tr>
<tr>
<td width="137" height="50"><b><font face="Arial">Email
Address: </font></b></td>
<td height="50" width="265"><font face="Arial">
<a href="mailto:">
<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="1"
i-maximum-length="25" --><input type="text" name="Email" size="20"
maxlength="25" tabindex="3"></a></font></td>
</tr>
<tr>
<td width="137"><b><font face="Arial">Problem or Need:<br>
Be Specific!! </font></b></td>
<td width="265"><font face="Arial">
<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="1"
i-maximum-length="400" --><textarea rows="6" name="Problem" cols="25"
tabindex="4"></textarea></font></td>
</tr>
<tr>
<td width="402" colspan="2">

<p align="left">
<input type="submit" value="Submit" name="B1" style="border: 8px outset
#FF0000" tabindex="5"></p>
<p class="MsoNormal"><i><b><font face="Arial" size="1">Web Page Created By
John Rose<br>
2004/2005</font></b></i></p>
</td>
</tr>
</table>

<input type="hidden" name="status" value="o">
<input type="hidden" name="ID" value=""autonumber"">


<input type="hidden" name="image"
value="images/nowserving/image<%=fp_db("ID")%>.gif">


</form>

</body>
 
Try this:

<input type="hidden" name="status" value="o">
<input type="hidden" name="ID" value=""autonumber"">
<input type="hidden" name="image" value="images/nowserving/image<%=FP_FieldVal(fp_rs,"ID")%>.gif">

If the above doesn't work, maybe Kathleen has some thoughts since she works with the FP Database
components, whereas I hand code everything.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


databaseboy2005 said:
Intesting, but the code on the referenced page only goes up to 200. I think
it may be refering to the "_fpclass/fpdbrgn1.inc" file...but again not sure.
The code below is from the reference page and starts on line 147-200.


<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="6079" --><tr>
<td><img src= "<!--webbot bot="DatabaseResultColumn"
s-columnnames="Status,ID,Name,Room,Email,Image,Problem,Remote_computer_name1,User_name1,Browser_type1,Timestamp1"
s-column="Image" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Image<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Image")%>"><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="8552" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
width="100%"><font color="#000000">This is the end of a Database Results
region.</font></td></tr>" startspan --><!--#include
file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>

</table>

<p> </td>
</tr>
<tr>
<td width="137" height="48">
<p align="left"><b><font face="Arial">Room#: </font></b></p>
</td>
<td height="48" width="265"><font face="Arial">
<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="1"
i-maximum-length="15" --><input type="text" name="Room" size="9"
maxlength="15" tabindex="2"></font></td>
</tr>
<tr>
<td width="137" height="50"><b><font face="Arial">Email
Address: </font></b></td>
<td height="50" width="265"><font face="Arial">
<a href="mailto:">
<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="1"
i-maximum-length="25" --><input type="text" name="Email" size="20"
maxlength="25" tabindex="3"></a></font></td>
</tr>
<tr>
<td width="137"><b><font face="Arial">Problem or Need:<br>
Be Specific!! </font></b></td>
<td width="265"><font face="Arial">
<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="1"
i-maximum-length="400" --><textarea rows="6" name="Problem" cols="25"
tabindex="4"></textarea></font></td>
</tr>
<tr>
<td width="402" colspan="2">

<p align="left">
<input type="submit" value="Submit" name="B1" style="border: 8px outset
#FF0000" tabindex="5"></p>
<p class="MsoNormal"><i><b><font face="Arial" size="1">Web Page Created By
John Rose<br>
2004/2005</font></b></i></p>
</td>
</tr>
</table>

<input type="hidden" name="status" value="o">
<input type="hidden" name="ID" value=""autonumber"">


<input type="hidden" name="image"
value="images/nowserving/image<%=fp_db("ID")%>.gif">


</form>

</body>

[QUOTE]
Also include a few lines above and below line 283.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
[/QUOTE][/QUOTE]
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced Database connections and Queries 1
auto fill based on another column data 1
Excel How to count from a column if specific condition in another column is true 3
Convert a field from long integer to Autonumber 2
matching & combining data from seperate worksheets 2
The database column "id" must be mapped to an input field... 1
Count the columns from one sheet and paste it in another sheet 0
Find a value in a sheet and replace it with another value if it matches 8

Back
Top