close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Error with "undefined"

Thread began 7/27/2012 12:16 pm by newreg192539 | Last modified 8/10/2012 12:48 pm by newreg192539 | 1031 views | 9 replies |

newreg192539

Error with "undefined"

The search page throws an error
Microsoft JET Database Engine error '80040e37'

The Microsoft Jet database engine cannot find the input table or query 'undefined'. Make sure it exists and that its name is spelled correctly.

/delta/DeltaAlloys_search.asp, line 13

In the recordset everywhere there should be a table or field and the query name is undefined instead. I reworked the wizard and got the same results. I can manually change everything on the page, but that is why I have DataAssist - so I don't have to write the code for this.
And while I am in a bummed mood I think it rotten that a forum is the best I can do when their product isn't working.

Sign in to reply to this post

Jason ByrnesWebAssist

please send a copy of your page so I can examine the code.


also, what version of data Assist?

What is your Operating System?

and What version Of Dreamweaver are you using?

Sign in to reply to this post

newreg192539

File attached

My Computer windows 7 - server Windows ? (iPower)
DataAssist 2
Can be seen at DeltaAlloys_search.asp

Sign in to reply to this post

newreg192539

DW Version

Forgot to put the DW version: CS5

Sign in to reply to this post

Jason ByrnesWebAssist

please send a copy of the delta/DeltaAlloys_search.asp page in a zip archive so I can see the code.

Sign in to reply to this post

newreg192539

Zipped Code

I attached the file before, but didn't realized it needed to be zipped. While I am at it I have put the results page and details in also.

Attached Files
code.zip
Sign in to reply to this post

Jason ByrnesWebAssist

So it looks like the issue is the recordset being used to populate the Alloy Group select list.

How is that table defined? can you send a screen shoot showing how the Allow group table is created.

Sign in to reply to this post

newreg192539

What?

I am not sure what you are requesting? Do you mean a screenshot of the table or a screenshot of the design view of the table or ? ? ? At any rate for me this is a moot issue now. While waiting I created my own code using dreamweaver.

Sign in to reply to this post

Jason ByrnesWebAssist

I meant a screen shoot of MS Access showing the how the table is defined, column names and data types.

Sign in to reply to this post

newreg192539

Designview of Table

The design view of the table is attached.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...