My SQL

	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

My SQL

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 >> My SQL

Page: [1]

Topic Starter

Posts: 49
From: Canada, eh?
Status: offline

My SQL - 4/9/2001 20:42:00

Why am I getting a syntax error for this?

UPDATE Results SET
Title='::Title::',
Date=': ate::',
Author='::Author::',
Lead_In='::Lead_In::',
Rest_Of_Article='::Rest_Of_Article::'
WHERE ID=::ID::

My ID field is AutoNumber, Title, Date, and Author are Text, Lead_In and Rest_Of_Article are memo fields..

Thanks!!

Vince from Spain

Posts: 658
From: Madrid Spain
Status: offline

RE: My SQL - 4/9/2001 23:15:00

At a guess because Date is an ASP function that displays todays date. Try changing it to . . .
myDate='::myDate::',
. . . and changing the database field accordingly.
Also, while you are in the database, why have you used memo fields for everything apart from the id? Where possible use text fields as they will be more efficient.

All the best

Vince

------------------
Internet Business Solutions S.L.(Spain)

(in reply to Topic Starter)


Topic Starter Posts: 49 From: Canada, eh? Status: offline	RE: My SQL - 4/9/2001 23:34:00 Darn!! Thanks Vince!! As for the memo fields some of the articles are pretty long, longer than th 250 maximum set by a text field.... (in reply to Topic Starter)