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

iRite won't display contents of memo field from Access DB

Thread began 4/01/2009 11:34 am by ianh299316 | Last modified 4/02/2009 6:27 am by ianh299316 | 3697 views | 4 replies |

YellowCircleWeb

iRite won't display contents of memo field from Access DB

I'm trying to create an update form for a site. I want to display the contents of a memo field from my Access database in the iRite editor but I get the following error:

Invalid use of Null: 'cStr'

I know that there is content in the field as I've created a normal text field above my iRite editor that displays the contents of the memo field without any problems. I've also tried removing the cStr function from the iRite code but I still can't get anything to display in my iRite editor.

Any help with this would be much appreciated. I'm working in ASP btw, not php

Sign in to reply to this post

Ray BorduinWebAssist

This means that you have a null field in your database. What happens when you remove the cStr? That is probably the best route if you are trying to stop the error.

What does the code look like on the line throwing the error? I'd say probably remove it and start debugging the other issue. It looks like your field is blank, so it wouldn't show anything. Maybe this is really a problem with the insert page not inserting a value in the first place.

Sign in to reply to this post

YellowCircleWeb

"I know that there is content in the field as I've created a normal text field above my iRite editor that displays the contents of the memo field without any problems."

No, it's not a null field and I've tried removing the cStr function and still nothing. No matter what I do the iRite box displays no content. It will display content from all other fields apart from the memo field.

I'm totally stumped on this

Sign in to reply to this post

Ray BorduinWebAssist

That error means you are passing a null value to the cStr function... so maybe the error is coming from somewhere else or it is being cleared or it has a typo.

I also remember funny problems with cursor types and memo fields in ASP with Access. You may be running into that problem... if you remove the display above does it appear correctly? I may be wrong but I think sometimes they could only be referred to once depending on the connection type.

Sign in to reply to this post

YellowCircleWeb

Ray,

Thanks for the help with this. You were right the memo field value could only be passed once and due to the fact that I was using a text field above my iRite box to display the contents of the memo field, the iRite box wasn't able to display the value.

Although I've no need to change the cursor type for my web app I believe that if you change it to adOpenDynamic then you can display the contents of a memo field more than once in a page. Thought this may help other people.

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