472,353 Members | 2,258 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.



I am converting a VB .ASP using an Access Databese program to a
VB .ASP using a SQL database, I am almost done There is one problem,
I have a field which is a ntext (memo field in Access) that won't
display in a HTML table:

"<td><font size="2"><%=MRMTitle%></font></td>"

It will show up as a response.write: " Response.Write("<p>Req = " +
rsMRM("Requirements_Long") + "<p>")"
Everything else shows up in my program, except for this one thing. I
have a co-worker and a friend both helping me, and both are stumped. I
am very confused. Can anyone help me with this?

Here is my main Select:

" qryString = "SELECT [General/Meeting Title], [Meeting Start],
[Meeting End], [Group_ID], [Requirements_Long], Rooms.[Meeting
qryString = qryString & " [Notification/EMail] FROM Reservations"
qryString = qryString & " INNER JOIN Rooms ON Reservations.Room_ID
= Rooms.Room_ID"
qryString = qryString & " WHERE (((Reservations.[Meeting
Start])>'" & startDateNew & "')"
qryString = qryString & " AND ((Reservations.[Meeting End])<'" &
endDateNew & "')) ""

Once I open the query then I loop through processing the data. I try
to assign [General/Meeting Title] to a variable, MRMTitle, but it is
blank. Like I said it will print with a response.write but nothing

I forgot to mention that in the Access database the [General/Meeting
Title] is a memo field, here in the converted SQL database, [General/
Meeting Title] is now a NTEXT field. I do not know if that makes a
difference or not.

If anyone needs more info, I will be happy to give it.

Apr 22 '07 #1
1 1463
Joe wrote:

I am converting a VB .ASP using an Access Databese program to a
VB .ASP using a SQL database, I am almost done There is one problem,
I have a field which is a ntext (memo field in Access) that won't
display in a HTML table:

Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
Apr 22 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: William C. White | last post by:
Does anyone know of a way to use PHP /w Authorize.net AIM without using cURL? Our website is hosted on a shared drive and the webhost company...
by: Albert Ahtenberg | last post by:
Hello, I don't know if it is only me but I was sure that header("Location:url") redirects the browser instantly to URL, or at least stops the...
by: James | last post by:
Hi, I have a form with 2 fields. 'A' 'B' The user completes one of the fields and the form is submitted. On the results page I want to run a...
by: Ollivier Robert | last post by:
Hello, I'm trying to link PHP with Oracle 9.2.0/OCI8 with gcc 3.2.3 on a Solaris9 system. The link succeeds but everytime I try to run php, I get...
by: Richard Galli | last post by:
I want viewers to compare state laws on a single subject. Imagine a three-column table with a drop-down box on the top. A viewer selects a state...
by: Albert Ahtenberg | last post by:
Hello, I have two questions. 1. When the user presses the back button and returns to a form he filled the form is reseted. How do I leave...
by: inderjit S Gabrie | last post by:
Hi all Here is the scenerio ...is it possibly to do this... i am getting valid course dates output on to a web which i have designed ....all...
by: Jack | last post by:
Hi All, What is the PHP equivilent of Oracle bind variables in a SQL statement, e.g. select x from y where z=:parameter Which in asp/jsp...
by: Sandwick | last post by:
I am trying to change the size of a drawing so they are all 3x3. the script below is what i was trying to use to cut it in half ... I get errors....
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.