Local Resources

Select code from states where statename = '#statename#' select statename from states where code = '#url.state#' Local Resources for #statename# select Localresourcesinfo_name, Localresourcesinfo_City, Localresourcesinfo_Phone, Localresourcesinfo_email, Localresourcesinfo_link, Localresourcesinfo_description, Localresources_source from Localresourcesinfo, Localresources where Localresourcesinfo_State = '#statecode#' and Localresourcesinfo_Localresources = #url.Localresourcesinfo# and Localresourcesinfo_Localresources = Localresources_ID order by Localresourcesinfo_name select Localresourcesinfo_name, Localresourcesinfo_City, Localresourcesinfo_Phone, Localresourcesinfo_email, Localresourcesinfo_link, Localresourcesinfo_description, Localresources_source from Localresourcesinfo, Localresources where Localresourcesinfo_State = 'NA' and Localresourcesinfo_Localresources = #url.Localresourcesinfo# and Localresourcesinfo_Localresources = Localresources_ID order by Localresourcesinfo_name Select top 5 * from NFIBWeekly where (NFIBWeekly_Category='State and Local Highlights') and (NFIBWeekly_State='#url.state#') and (NFIBWeekly_date >= dateadd(day, -60, getdate()) and NFIBWeekly_date <= getdate()) order by NFIBWeekly_date desc
Select State#statename#

Local #getlocalinfo.Localresources_source# information

#Localresourcesinfo_name#
City: #Localresourcesinfo_City#
Phone: #Localresourcesinfo_Phone#
Email: #Localresourcesinfo_email#
Website: #Localresourcesinfo_link#
Description: #Localresourcesinfo_description#


National Listing

#Localresourcesinfo_name#
City: #Localresourcesinfo_City#
Phone: #Localresourcesinfo_Phone#
Email: #Localresourcesinfo_email#
Website: #Localresourcesinfo_link#
Description: #Localresourcesinfo_description#


NFIB State and Local Highlights
  • #NFIBWeekly_Title# (#dateformat("#NFIBWeekly_date#","mm/dd/yyyy")#) #NFIBWeekly_content#
Education and Training: select * from Localresourcesinfo where Localresourcesinfo_State = '#statecode#' and Localresourcesinfo_Localresources = 2 select * from Localresourcesinfo where Localresourcesinfo_State = '#statecode#' and Localresourcesinfo_Localresources = 1 select * from Localresourcesinfo where Localresourcesinfo_State = '#statecode#' and Localresourcesinfo_Localresources = 3 select * from Localresourcesinfo where Localresourcesinfo_State = '#statecode#' and Localresourcesinfo_Localresources = 4 select * from Localresourcesinfo where Localresourcesinfo_State = '#statecode#' and Localresourcesinfo_Localresources = 5 select * from Localresourcesinfo where Localresourcesinfo_State = '#statecode#' and Localresourcesinfo_Localresources = 6 select * from Localresourcesinfo where Localresourcesinfo_State = '#statecode#' and Localresourcesinfo_Localresources = 7 select * from Localresourcesinfo where Localresourcesinfo_State = '#statecode#' and Localresourcesinfo_Localresources = 8