Why won't my update.asp work?

	Home Register Search Help Login

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

Search Forums

Recent Posts

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

Why won't my update.asp work?

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 and Database >> Why won't my update.asp work?

Page: [1]

djheywood

Posts: 8
From: Los Angees, CA
Status: offline

Why won't my update.asp work? - 7/6/2001 20:11:00

I am trying to update an access table from within Frontpage using the DRW. I have a table 'PlayerAttributes' with the fields player, NFLTeam, height, weight, college, and drafted. I want to update the drafted column with either the team that owns that player or the word 'free' if the player is available. The record I am trying to update is starting out with the word 'Brian' in the drafted field. From a DRW in frontpage I can select a release hyperlink next to the player I want to release and that takes me to my team_deletions.asp page. This page has nothing except a DRW with the update code in it. I have the page redirected to a displayteam.asp page in 1 second. On the team_deletion.asp page I have a DRW with the following SQL code:

UPDATE PlayerAttributes SET PlayerAttributes.Drafted = "Free"
WHERE Player= ::Player::

I have also tried:

UPDATE PlayerAttributes SET PlayerAttributes.Drafted = "Free"
WHERE (Player= '::Player::')

The page processes without any error messages, and forwards me to my team display page but the access tables are not updated. Any idea why? Do I need all the fields in the table passed to update one?

Please help.

Thank You.

Brian


Spooky Posts: 26603 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Why won't my update.asp work? - 7/6/2001 20:21:00 HAve you tried option 2 with 'Free' and not "Free" ? ------------------ ��k� "I am Spooky of Borg. Prepare to be assimilated, babycakes!" Subscribe to OutFront News Database / DRW Q & A The Spooky Login! VP-ASP Shopping cart (in reply to djheywood)

djheywood

Posts: 8
From: Los Angees, CA
Status: offline

RE: Why won't my update.asp work? - 7/6/2001 23:03:00

I will give it a try, although I know I tried the single quote at some point. If it doesn't work I'll write back.

Thanks,

Brian

(in reply to djheywood)

djheywood

Posts: 8
From: Los Angees, CA
Status: offline

RE: Why won't my update.asp work? - 7/7/2001 20:45:00

It Works!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Spooky you really are the best. I was banging my head against the wall (literally) all day yesterday.

Thank you very much for all the time and effort you spend helping the rest of us!

Brian

(in reply to djheywood)


Spooky Posts: 26603 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Why won't my update.asp work? - 7/7/2001 20:32:00 Phew (in reply to djheywood)