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!
read the following to set them up locally
settingPermissions.htm
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