Database Management
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDatabase Management

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old January 23rd, 2004, 12:13 PM
jDan jDan is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Posts: 13 jDan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Double Quotes in Access Output to form

I am trying to fill a form with output from an access database, but it's cutting the data if double quotes (") are used.

Here's a sample of one of my fields:

<tr><td>
Description:</td><td>
<input type = "Text" size = '50' name = "Description"
value = "<% response.write rs2("Description")%> ">
</td></tr>

Now if I were to write, on it's own:
Response.write rs2("Desription")

I get the full output:
Featured in “The Prince”, an adaptation of Hamlet

But in the input text box above, I get:
Featured in

It's obviously reacting poorly to being placed in the HTML form.... anyone got any ideas?

Cheers-

dan

Reply With Quote
  #2  
Old January 23rd, 2004, 12:19 PM
jDan jDan is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Posts: 13 jDan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Also, a quick update-

it works fine for chr(147) and chr(148) - these are open and close double quotes, respectively. It doesn't work for chr(34), which is a generic open and close quote- the kind you'd use in Notepad.

Reply With Quote
  #3  
Old February 15th, 2004, 12:59 PM
aramtch aramtch is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 1 aramtch User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Wink RE: Double Quotes in Access Output to form

jDan,

instead of chr(34) try using " - that did the trick for me.

Aram

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDatabase Management > Double Quotes in Access Output to form


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway
Stay green...Green IT