CoverYourASP --> Snippets

Free membership

Join in the fun! Sign in
Member Services

Site navigation
Download the entire site!
Search my articles
Free Magazines
Browse the directory

Send me feedback
Buy my boxer shorts

Recommend this page
Printer-friendly page

Resources I recommend
Link to my site
Advertising slashed!
About your privacy
Legal stuff
Site statistics
32 active users
2328 visitors today
2019 pages today
(only part of today)
Tools I use

CoverYourASP
Copyright © 1999-2016 James Shaw.
All rights reserved.

ASP.NET Blog
RSS submissions
E-commerce

Now open source with SourceForge!

"Snippets" are mini-articles - they allow me to very quickly add answers to your frequently asked questions, and add brief explanations for topics that you've searched for without success. So, everytime you send an email or perform a search, chances are a new snippet will be the result!

16 Sep: Syntax error in FROM clause - using the SECRET password

If you're trying to use the SECRET password as described on the security page, you might have come across errors like Syntax error (missing operator) in query expression or Syntax error in FROM clause.

If so, you've probably added ?SECRET=1 to the URL, even when the URL has a ? already.

For example, use

    http://localhost/cya/DBEditRecord.asp?table=Affiliates&AffiliateID;=2&SECRET;=1,

not

    http://localhost/cya/DBEditRecord.asp?table=Affiliates&AffiliateID;=2?SECRET=1.

Featured sponsor
My favorite resources

CoverYourASP Mugs, T-shirts, caps - even Boxer shorts...
I don't make a penny from these, but they're a lot of fun! Don't you need a new mouse mat?


See my source code
wherever you see this icon...

You can also download the entire site source code for FREE!