RE: Updating Access DB from .asp Form

	Home Register Search Help Login

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sponsors
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

RE: Updating Access DB from .asp Form

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> RE: Updating Access DB from .asp Form

Page: << < prev 1 2 [3]


Long Island Lune Posts: 2340 Joined: 6/8/2002 From: New York Status: offline	RE: Updating Access DB from .asp Form - 10/31/2003 14:28:24 Glad to see you got it in. Your almost there. Note my change below. Try that. <!--#include file="_fpclass/fpdbrgn1.inc"--> <!--webbot bot="DatabaseRegionStart" endspan --><table BORDER="0"> <tr> <td valign="top"><font face="Lucida Sans" size="2"> <%=mid(FP_FieldVal(fp_rs,"nwDate"), 6, 2) & "/" & right(FP_FieldVal(fp_rs,"nwDate"), 2) & "/" & left(FP_FieldVal(fp_rs,"nwDate"), 4)%> </font></td> <td><font face="Lucida Sans" size="2"> <%=FP_FieldVal(fp_rs,"nwNews")%></font></td> </tr> </table> < Message edited by Long Island Lune -- 11/3/2003 10:09:02 PM > _____________________________ (in reply to D_Sutter)


Long Island Lune Posts: 2340 Joined: 6/8/2002 From: New York Status: offline	RE: Updating Access DB from .asp Form - 11/3/2003 14:30:53 Did that fix it? _____________________________ (in reply to Long Island Lune)


D_Sutter Posts: 48 Joined: 10/4/2002 Status: offline	RE: Updating Access DB from .asp Form - 11/3/2003 14:36:24 I'm sorry...I forgot to post back. YES...that made it do exactly what I was trying to do. Now I just wish Frontpage would quit changing it all back when I go in to change something else. I have to edit the pages with another editor to get it to keep those changes. You know of an easier way? Don (in reply to Long Island Lune)


Long Island Lune Posts: 2340 Joined: 6/8/2002 From: New York Status: offline	RE: Updating Access DB from .asp Form - 11/3/2003 14:46:37 Hi Don, Yeah, FP can be a royal pain when it comes to altering code in a DRW region. Do you know how to put a DRW region on a Spooky diet? It is VERY EASY and will allow you to gain complete control over everything inside the DRW region, while still allowing FP to complete your DRW task. And that means no overwriting when you save the page either. Here is the link to his Diet. http://www.outfront.net/spooky/adv_drw_diet.htm Check it out when you get a chance. It's only a matter of removing certian lines from your DRW region. That's it. Then you will have complete control in the DRW region. Once you go Diet - you will never look back. < Message edited by Long Island Lune -- 11/3/2003 2:47:04 PM > _____________________________ (in reply to D_Sutter)


D_Sutter Posts: 48 Joined: 10/4/2002 Status: offline	RE: Updating Access DB from .asp Form - 11/3/2003 14:54:55 Thanks...I'll give it a try...can always benefit from going on a diet... Don (in reply to Long Island Lune)

Long Island Lune

Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline

RE: Updating Access DB from .asp Form - 11/3/2003 22:08:02

quote:

ORIGINAL: Long Island Lune

Glad to see you got it in. Your almost there. Note my change below. Try that.


<table BORDER="0">
<tr>
<td valign="top"><font face="Lucida Sans" size="2">
<%=mid(FP_FieldVal(fp_rs,"nwDate"), 6, 2) & "/" & right(FP_FieldVal(fp_rs,"nwDate"), 2) & "/" & left(FP_FieldVal(fp_rs,"nwDate"), 4)%>
</font></td>
<td><font face="Lucida Sans" size="2">
<%=FP_FieldVal(fp_rs,"nwNews")%></font></td>
</tr>
</table>

quote:

Very good Don.

_____________________________

(in reply to Long Island Lune)


D_Sutter Posts: 48 Joined: 10/4/2002 Status: offline	RE: Updating Access DB from .asp Form - 11/5/2003 14:59:37 Well I've gotten started and more questions just keep coming up. I have a database that I am updating that I have displaying multiple records on 1 form. 1. Can I do this? 2. How do I make it update the right records? I have it put the information into form fields and saving the record ID as well. I send this information to another .asp page to update. I have tested to make sure the information is getting to the update asp and it is. The information comes in like... ID = 3,4,5 AWD = something, something else, something else It puts the information together like that. It doesn't give me any error messages, but the data is not being updated. Don (in reply to Long Island Lune)


Long Island Lune Posts: 2340 Joined: 6/8/2002 From: New York Status: offline	RE: Updating Access DB from .asp Form - 11/5/2003 21:39:40 quote: I have a database that I am updating that I have displaying multiple records on 1 form. I'm not sure I understand. You have a database returning multiple records? Or your filling your form with multiple records? Or both? < Message edited by Long Island Lune -- 11/6/2003 7:05:02 AM > _____________________________ (in reply to D_Sutter)


Spooky Posts: 26680 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Updating Access DB from .asp Form - 11/5/2003 23:01:58 If you want a hand, let me know - Ive got a little lost with the length of this thread ;-) _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s


D_Sutter Posts: 48 Joined: 10/4/2002 Status: offline	RE: Updating Access DB from .asp Form - 11/6/2003 6:52:23 I'm sorry for the length of this posting. It seems that one question leads to another and Mr. Long Island Lune has been so helpful, I just keep posting here. Thank you for providing this forum...has been extremely helpful. Don (in reply to Spooky)


Long Island Lune Posts: 2340 Joined: 6/8/2002 From: New York Status: offline	RE: Updating Access DB from .asp Form - 11/7/2003 13:44:21 It seems apprent that Spooky did not read this entire thread. If he would have, he would have saw that the original question was answered a long time ago. Then another question was posted and answered. Then another. So this single thread has handled a total of 4 separate questions. The best thing to do is to close this thread. Post additional questions in a new thread in the ASP / Database forum. LLLuneeeee < Message edited by Long Island Lune -- 11/7/2003 3:34:32 PM > _____________________________ (in reply to D_Sutter)

Page: << < prev 1 2 [3]

All Forums >> Web Development >> ASP, PHP, and Database >> RE: Updating Access DB from .asp Form

Page: << < prev 1 2 [3]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts