Skip Navigational Links
LISTSERV email list manager
LISTSERV - COMMUNITY.EMAILOGY.COM
LISTSERV Menu
Log In
Log In
LISTSERV 17.5 Help - LSTSRV-L Archives
LISTSERV Archives
LISTSERV Archives
Search Archives
Search Archives
Register
Register
Log In
Log In

LSTSRV-L Archives

LISTSERV Site Administrators' Forum

LSTSRV-L

Menu
LISTSERV Archives LISTSERV Archives
LSTSRV-L Home LSTSRV-L Home

Log In Log In
Register Register

Subscribe or Unsubscribe Subscribe or Unsubscribe

Search Archives Search Archives
Options: Use Forum View

Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Constraint returns rows, results in no mail.
From:
Michael McIntire <[log in to unmask]>
Reply To:
LISTSERV give-and-take forum <[log in to unmask]>
Date:
Mon, 25 Nov 2002 13:51:36 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (28 lines)
I have been trying to use/test mail merge, and am having some difficulty
with constraining, specifically using the list specific mail merge forms
on the web interface. When I use an inequality, I get all rows, when I use
an equality, I get no rows – which makes some sense if you presume that
the system is comparing apples and oranges.

While I think I have things setup correctly, I could not find in the
documentation anything that described in absolute terms what was required
to use the DBMS interface. The system is Win2K ADVSRV, using
SQLServer2000. The list accesses the data table through a view, which
should be inconsequential though I have noted from some of the archives
the first column is/was required to be the email address.

I can see the statement “select * from v_msmtest” goes to the log, and
returns rows, which tells me that the comparison is done inside the lsoft
engine. Does anyone have any ideas on how I can debug this, or if there is
more detailed documentation on the requirements to setup a table? Is it
possible that the char data is being returned as Unicode?

Any help would be appreciated.

Michael McIntire

DBMS interface
ODBC
equality
constraint

ATOM RSS1 RSS2

COMMUNITY.EMAILOGY.COM CataList Email List Search Powered by LISTSERV