RE: Updating Access DB from .asp Form (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

Long Island Lune -> 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>



Long Island Lune -> RE: Updating Access DB from .asp Form (11/3/2003 14:30:53)

Did that fix it?



D_Sutter -> 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



Long Island Lune -> 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. [;)][:)]



D_Sutter -> 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



Long Island Lune -> 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.


<!--#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>

quote:

Very good Don.



D_Sutter -> 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



Long Island Lune -> 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?



Spooky -> 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 ;-)



D_Sutter -> 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



Long Island Lune -> 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 [:)]



Page: <<   < prev  1 2 [3]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.078125