Sage CRM

Welcome to the Sage CRM Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Formulate a SQL string to display results to a LIST block via ASP

Posted By adriant over 9 years ago

Hi All,

I am trying to render a LIST block to screen via an ASP page – however I need to create a complex SQL string in the ASP page that will retrieve the rows to display in the list. Can you please advise on how i can formulate a sql string and execute the results to the list block in ASP?

Thanks

Adrian

0 1322397 over 9 years ago

Hi Adrian,

When we create any List block in Sage CRM, it is mandatory to enter Table or view name. Fields in List block are the fields from this provided view or table, also rows displayed in list block are the rows returned by view. So either you can create a view of your SQL String and using this view you can create a list block or below is the link which is similar to what you are looking for.

https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2009/06/09/building-lists-without-reference-to-meta-data-in-the-asp-com-api.aspx

Hope this helps!

Regards,
Dinesh
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage CRM

Formulate a SQL string to display results to a LIST block via ASP

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING