DwZone Forum Welcome to the DwZone-it Forum     FAQ   Search   Memberlist   Usergroups       Register -->   Login   Advanced Mail   DwZone Forum Index -> Advanced Mail Moderators: Administrators, Moderators  Mark all topics read Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes. Search for  View  Normal Expanded Dynamic Dynamic Memory Threaded Threaded Expanded Threaded Dynamic    Per page  102550    Messages Since  Last Visit Last Day Last Week Last Month Last 6 Months Last Year All Messages 71 to 80 of 781 (Total: 224) First |  Prev |  Next |  Last    Subject Author Date      Cannot send e-mail if the clause WHERE is present    [email protected]   10:54 30 Mar 2010      Re:Cannot send e-mail if the clause WHERE is present    gianluigi   11:15 30 Mar 2010      Re:Cannot send e-mail if the clause WHERE is present    [email protected]   11:37 30 Mar 2010      Re:Cannot send e-mail if the clause WHERE is present    gianluigi   11:40 30 Mar 2010       Re:Cannot send e-mail if the clause WHERE is present    [email protected]   11:46 30 Mar 2010     The only way to get around this issue was to create a view in the SQL Server that will filter out the N records and then, In Advanced Mail build the query using your query manager against that view instead of querying the initial table. That works, but it's double the work. Thanks for your answers. Adrian          HTML AND ONLYText for body    [email protected]   15:20 15 Oct 2009      Re:HTML AND ONLYText for body    gianluigi   10:05 16 Oct 2009      Re:HTML AND ONLYText for body    [email protected]   11:03 16 Oct 2009      Re:HTML AND ONLYText for body    gianluigi   3:22 1 Nov 2009      File With Same Name Not Attached    [email protected]   8:40 28 May 2009   Last Visit: Saturday 10 May, 2025 4:39 pm First |  Prev |  Next |  Last    Login Username:  Password:   Log me on automatically each visit:   Read Message   Unread message Read message [popular]   Unread message [popular] Read message [locked]   Unread message [locked] All times are GMT-2 Jump to:  Select a forum    Php Extensions --------------------  » Advanced Form Controls  » Advanced Image Gallery  » Advanced Mail  » Advanced Search  » Ajax DataGrid  » Ajax loader  » Boolean Update  » Dynamic Captcha Image  » Dynamic Chart  » Dynamic Image  » Form Validator  » Google Maps  » HTML to PDF  » Import/Export Tools  » Multi Column Combo  » Multiple file upload  » Multiple Record  » Other extensions  » PayPal IPN  » Query Manager and Recordset Wizard  » Recordset Paging  » Server Side Validation  » Shopping Cart  » Site Search Engine  » TreeView  » Two tables manager  » Upload and resize  » WYSIWYG Html Editor  Asp Extensions --------------------  » Advanced Form Controls  » Advanced Image Gallery  » Advanced Search  » Advanced Mail  » Ajax DataGrid  » Ajax loader  » Asp TreeView  » Asp Upload and Resize  » Boolean Update  » Dynamic Captcha Image  » Dynamic Chart  » Dynamic Image  » Form Validator  » Google Maps  » HTML to PDF  » Import/Export Tools  » Multi Column Combo  » Multiple file upload  » Multiple Record  » Other extensions  » PayPal IPN  » Query Manager and Recordset Wizard  » Recordset Paging  » Routing Map24  » Server Side Validation  » Shopping Cart  » Site Search Engine  » Two tables manager  » WYSIWYG Html Editor