You may get errors such as
Internal error 500
or
Operation must use an updateable query.
make sure you ask your isp to set up these permissions!
you can read the threads below for more information
on how to fix the error ' operation must use an updateable
query '
Thread:
Operation must use an updateable query
Thread:
Operation must use an updateable query. How to fix
Field names
If you are experiencing problems on UPDATE OR
INSERT statements please make sure you have not named
any of your fields as a reserved word. Typical examples
are naming a field 'date' or 'time' - these are reserved
words in sql and will cause errors in insert and update
statements.
For a full list of reserved sql keyword's in access
2000 click
here
You may experience warning's
warning codes
wrng:1 - front end wont work administration wont
work - asp files not created
-usual cause no primary key defined in that table.
solution - make sure you have a primary key - recommended
to create a field as an autonumber and use that field
as your primary key.
wrng:2 - front end will work - administration may
not work expect java script errors and
errors on insert and update. - usual cause - badly
named fields
doesnt support OLE Object fields (blob field - commonly
used for storing pictures or files)
doesnt support joined keys
doesnt work on password protected databases
javascript validation
In the administration section you will notice
that little red stars denote fields that are required.
A field is deemed required if it's property is set
to 'required' in the database table.
OR if the property 'allow zero length' is set to NO.
date validation
although date fields are detected during the generate
asp routine - java script validation of dates is not
included. this is due in main to regional variations
and differing formats being so wide as it was deemed
wisest to allow
the individual developer to do validation for this.
numeric values
these are defaulted to 0 if nothing is added and they
are not 'required'
this prevents an error.
server problems
if you are receiving error such as 'cannot find server'
then you will probably be having personal web server
ort iis problems.
Make sure IIS is installed by going to control panel(win2000\xp
pro) and looking at add\remove programs\windows components.
You might find this
article useful for configuring iis.
Have XP home edition and want to install IIS - You
could read
this?
You could read
this article on setting up personal web server.
Make sure pws\iis is running and make sure you access
your pages via a browser by http://localhost/yourDB/
and *not* by double clicking on the file. or using
file-open to go to say contactlist.asp.
asp files must be run through http\\localhost (this
means they are processed with pws or iis rather than
just the browser which is what is hapenning of you
just double click.
asp links
aspmessageboard
an invaluable resource for solving problems.
vbscript
reference
whats was that function...?
find interdev to clunky? checkout allaire
homesite ( macromedia )
The best asp\html editor out there - integrates seamlesly
with dreamweaver.
Has an integrated snippets utility (excellent!) for
storing useful code and loads of useful plugin functions
that you can download from here
- (make sure you check out the response.writer, comment\uncommenter
and the function browser these are 3 plugins that i
use a whole lot.)
still stuck?
click here to
email support
