Jul 15
Stephen Smiroldo SQL statement and returned values blank
Jul 15, 2016; 10:40
Stephen Smiroldo
SQL statement and returned values blank
Anyone see anything wrong with this?
- - - - - - - - -
var:'sql_statement'=String;
$sql_statement+='SELECT email FROM mailing_list WHERE status=\'clean\' AND full_name<>\'null\'';
Inline: -SQL=$sql_statement,
-username=$un,
-password=(Decrypt_Blowfish2: (decode_base64:$pass), -Seed=$seed),
-Database=‘list’, -SortField='updated',-MaxRecords=100;
if(found_count);
records;
local: 'full_name' = field:'full_name';
output:(field:'email')+' ('+#full_name+')<br />',-EncodeSmart;
/records;
/if;
/inline;
- - - - - - - - - -
It’s outputting the “email” value but NOT the “full_name” value. I’ve also tried many other column names in this table but the ONLY value it’s pulling is the “email” column. I also created a new table and imported a CSV of the email list data into the new table but am getting the same results.
The data is there to pull the full name but it’s just not getting any value other than the email. Is there something obvious I’m missing?? I feel like Gremlins have invaded. ;-)
Stephen
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Jul 15
Peter D Bethke Re: SQL statement and returned values blank
Jul 15, 2016; 10:46
Peter D Bethke
Re: SQL statement and returned values blank
Jul 15
Stephen Smiroldo Re: SQL statement and returned values blank
Jul 15, 2016; 11:09
Stephen Smiroldo
Re: SQL statement and returned values blank
Jul 15
Peter D Bethke Re: SQL statement and returned values blank
Jul 15, 2016; 11:34
Peter D Bethke
Re: SQL statement and returned values blank
Jul 15
Peter D Bethke Re: SQL statement and returned values blank
Jul 15, 2016; 11:42
Peter D Bethke
Re: SQL statement and returned values blank