There are limitations in what you can do with queries with memo fields.
Some good KB articles with info, but basically if anything in the query
needs looking within the memo field itself, then it will only look at ( and
return ) the first 256 or so characters. The SELECT DISTINCT is just such a
case. Lose the DISTINCT and it will probably work.
Frågan#1
Av någon anledning hämtas inte all text i ett PM-fält (Access) utan texten klipps av mitt i. Jag har aldrig tidigare råkat ut för detta.
Den relevanta koden:
sql = "SELECT DISTINCT gallerycategories.* " &_
"FROM gallerycategories " &_
"WHERE categoryid IN (SELECT categoryid FROM galleries WHERE galleryid IN (SELECT galleryid FROM gallerypics))"
Set conn = OpenConn()
Set categories = conn.Execute(sql)
If Not categories.EOF Then
%>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<%
Do Until categories.EOF
desc = categories("description")
%>
<tr>
<td>
<strong><%=categories("name")%></strong>
<%
If Len(desc) > 0 Then
Response.Write "<br>" & desc
End If
%>