Data type
-
I'm displaying details on my website, which is taken from my MS access database. Which is simple enough. The details are shown in a table, which you can most probably tell from the extract of code. The problem is the "Address" appear on the site, but the "Details" do not. The difference is that on the database, the Address data type is text, and the Details is data type memo. I believe the problem lie with this difference in data type, and the If RS("Details") <> "" then. Hopefully someone can show me the light! <% If RS("Address") <> "" then Response.Write("
") Response.Write RS("Address") 'This does appear Response.Write("
") End if %> <% If RS("Details") <> "" then Response.Write("
") Response.Write RS("Details") 'This does not appear Response.Write("
") End if %> --- Peter M
-
I'm displaying details on my website, which is taken from my MS access database. Which is simple enough. The details are shown in a table, which you can most probably tell from the extract of code. The problem is the "Address" appear on the site, but the "Details" do not. The difference is that on the database, the Address data type is text, and the Details is data type memo. I believe the problem lie with this difference in data type, and the If RS("Details") <> "" then. Hopefully someone can show me the light! <% If RS("Address") <> "" then Response.Write("
") Response.Write RS("Address") 'This does appear Response.Write("
") End if %> <% If RS("Details") <> "" then Response.Write("
") Response.Write RS("Details") 'This does not appear Response.Write("
") End if %> --- Peter M
I've found out you cannot do comparisons with memo fields. You need to put it into a string to compare. Thanks to david wulff. --- Peter M