| Visit us at: http://www.db2asp.com |
FAQ
Q: I'm getting a "Must use updatable query" error message. What does this mean? How can
I fix it?
A: Almost always it is because of incorrect permission settings on the computer/server where the
database is. Make sure the IWAM_... user account has write permission for the mdb file or database. IIS
may not be using the IWAM_... account, in this case refer to your documentation. One for sure temporary
way to find out is to add the "Everyone" account and give it modify permission. Remember to undo this
later as it is not safe.
Q: How can I purchase DB2ASP?
A: You can pay online by Credit Card or use our other payments methods:
Click Here For Payment Methods And Information
Q: I can't link to the detail page, no link on results page to click on. Why?
A: This could be several things. 1) You didn't select any fields to display on the detail page; 2) Make sure
you have indicated a primary key field or fields; 3) You may need to select the primary key field to
display on the results page. See the Fields section of this help file
Q: I selected the page navition feature in the drop down box, but when my pages are
generate, there is no navigation. Why?
A: You probably de-selected the "include files" option. Since the navigation is created as an include file,
there can be no navigation. Please select the include files option (step 4, 'Advanced' tab).
Q: Do I have to select the autonumber field in my table? I don't want the autonumber field
to show on my web pages.
A: Your autonumber field makes a handy primary key, but you can let DB2ASP create one for you. In
any case, you can always set your autonumber field (or any field, for that matter) to not display in any of
your pages. See the Fields section of this help file.
Q: I want to customize my column names. How?
A: In the Fields window, you may customize the the displayed name of each field on the resulting page
by double clicking on the cell in the 'Display Name' column.
Or, just open the asp file you created with DB2ASP in your favorite HTML or text editor like Homesite,
InterDev, UltraEdit, TextPad, Notepad, etc. and change the name of the field/s in the A tag/s "Your Field
Name" in the example below:
TD ALIGN=left
< AHREF = "yourpage.asp">Your Field Name< /A >< /TD>
Q: What's the point of linking/joining tables?
A: So if you have a list of results, but you want the user to be able to quickly see a bit more data on each
of the results with just one click, this will put a link on each of your search results to the related fields in
another table. FOR EXAMPLE: Say you've got a table of your customers, and a table of your sales reps.
You search for all your customers in a particular state, or with a particular name, or whatever. Then,
when you're looking at this list of results, there's a link on the side of each customer that says "Sales
Rep". Click the link, and you're taken to the detail page for that customer's sales rep. Same for the
reverse. Say you're looking at the list of your sales reps, and you want to check each one's customer list.
If you've linked the tables, just click the link that says "customers" (or whatever you want to have the
link say), and you'll see a list of the customers associated with that sales rep. See the live demo for an
illustrated example.
Q:If I search on say a name and enter "ea" I would expect to return all names starting with "ea". However,
I am returning any name with "ea" anywhere in the field. Is there a wildcard I can use or some other solution?
A:This modification can be made easily. On the results page look for the field name in question and look for LIKE '%%'.
To change to search for beginning of text only, remove the first "%" sign.
Q:Is it possible that at the end of a form when i hit "add" I would like to go to a different form with the appropriate fields common to both forms filled in.
Best example would be if I were filling out a form called "quotation" and at the end
it was accepted, hitting "add" would take me to a form called "application" where the
"quotecode" would already be filled in.
A:Yes this can be done. This is not an automatic feature of DB2ASP, but since
it is 100% ASP code, the pages can be fully modified to do so.
We can help you do this with the purchase of the support plan (standard or premium).
Q: I'm getting a "syntax" error on my new asp page. Why?
A: First, try to get a more detailed error message.
Here's How: (You'll have to tweak a bit of code)
If its a SQL Syntax Error - Here's How:
If none of this is helpful:
Please zip and send directory where asp pages are, and email to support@303media.com.
Q: When clicking on the related records link on the results page, the link cannot be found.
What am I doing wrong?
A: In the DB2ASP program you need to select the related
or child table and the select fields for its results page. See the Fields and Link/Join
sections of this help file
Q: I'm using FrontPage to edit a generated Search page. I can create drop-down
list boxes to replace the text boxes for form fields, but how do I populate the list
with database values?
A: First, close DB2ASP.
Second, make sure you have a lookup table in you database. Say (States).
Third, open DB2ASP, on step 3, in the select fields window of the main table (Say Customers), click to open the look-up window for a particular field (State). Select the look-up table (States) and match the fields (State), in both tables, that have identical values.
Make sure you select the pages you want the drop-down lookup to appear (search, results, detail) on the look-up window.
That should do it. When you pages are created the look up should automatically be on the search page.
Q: How can I make DB2ASP work without using Personal Web Server?
A: You do NOT need PWS or IIS on your machine to create the asp pages. They
will be created on your local machine, but in order for the pages to work you will
need to move or copy the pages to a machine that does have PWS or IIS. You may need
to make adjustments for the database connection.
Q: How can I get my database fields that are of the checkbox type to display as checkboxes in the asp page? Currently the results are TRUE or FALSE.
A: Simply change the radio input tags to a checkbox tag:
---CHANGE---
INPUT TYPE=radio NAME="Field%=intCounter%" VALUE=1 %=RadioSelection(objRS("Field"), 1)%True
INPUT TYPE=radio NAME="Field%=intCounter%" VALUE=0 %=RadioSelection(objRS("Field"), 0)%False
---TO---
INPUT TYPE=checkbox NAME="Field%=intCounter%" VALUE=1 %=RadioSelection(objRS("Field"), 1)%br
Q: When I go to 'Finish', DB2ASP keeps looking for the database I was using before,
not the new one I specified in Step 2. Why?
A: Make sure you change the Web Site Root URL setting in Step 6, if your new database
is in a different folder. Also, always exit DB2ASP and restart it between sessions when
working with different databases.
Q:
A: