close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Type mismatch: 'URLencode'

Thread began 6/07/2009 7:15 pm by paul.urgero235355 | Last modified 6/08/2009 11:43 am by Ray Borduin | 2430 views | 3 replies |

Paul

Type mismatch: 'URLencode'

I've created an additional page to a website that I haven't touched in about a year...

I created a new table in Access, uploaded it, checked it and I can see my test text on the live page...no problem.

Now I'm trying to create the admin page, and on the results.asp page, I get this:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'URLencode'

/dbadmin/EventsDesc_Results.asp, line 581

Here is line 581:
<a href="EventsDesc_Detail.asp?Description=<%=(WADAEvents.Fields.Item("Description").Value)%>" title="View"><img border="0" name="View<%=(WADAEvents.Fields.Item("Description").Value)%>" id="View<%=Server.URLEncode((WADAEvents.Fields.Item("Description").Value))%>" alt="View" src="../WA_DataAssist/images/Slate/Refined_zoom.gif" /></a>

I updated dataAssist and Irite to the latest versions. I'm using DWCS4.

Appreciate the help.
Thanks

Sign in to reply to this post

Ray BorduinWebAssist

This is probably an issue with the ASP Recordset cursor and memo fields. Are any of these fields memo fields? I think this is probably as a result of dreamweaver updating the recordset code and not webassist extensions or functionality.

Sign in to reply to this post

Paul

As usual Ray...you hit it on the head. But isn't a Memo field able to accept more input data than a text field? I need it to take at least a full page of a Word doc at any time.

Also, as I go through the admin page, I click on the update button and I get this:

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/dbadmin/EventsDesc_Detail.asp, line 37

Line 37: Set WADAEvents = WADAEvents_cmd.Execute

Thanks

Sign in to reply to this post

Ray BorduinWebAssist

I think you can add code to update the cursor to work with memo fields.

I also think you can get a memo field value once and then can't get the value after, so you can store it in a variable on top of your page.

Sign in to reply to this post

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...