2. ASPRunnerPro General questions
  3. [SOLVED]  TableName_custom"
This topic is locked
[SOLVED]

 TableName_custom"

 		12/8/2010 8:51:41 PM
ASPRunnerPro General questions
A
 ArtH author

Please help as I have been trying this with no luck for almost 2 weeks.
This snipit works except for one part- My tables have text and what the result is from the Master -Details link
This script is suppose to take the below "ClusterQA" Table and populate a field with the words "not completed" until a link from the Master -Details shows up.
[color="#0000FF"]I have had ASP people & others, but no answer that will work.

I can not upload this to the demo site because of a company firewall...please help
set dal_TableName = dal.Table("ClusterQA") set rstmp =dal_TableName.Query("Node='" & data("Nodes") & "'","")

if not rstmp.eof then 'there is record in the detail table xt.assign "TableName_custom", ""

else

xt.assign "TableName_custom", "not completed"

end if

rstmp.close

set rstmp=nothing
[email="doyart@comcast.net"]Email me[/email]
A
 		ArtH author 12/8/2010

correction----The fields are Nodes & Nodes
set dal_TableName = dal.Table("ClusterQA") set rstmp =dal_TableName.Query("Node='" & data("Nodes") & "'","")

if not rstmp.eof then 'there is record in the detail table xt.assign "TableName_custom", ""

else

xt.assign "TableName_custom", "not completed"

end if

rstmp.close

set rstmp=nothing
A
 		ArtH author 12/10/2010

Solved by Jane!
Needed parenthesis around ("TableName_custom"),""
set dal_TableName = dal.Table("ClusterQA")

set rstmp =dal_TableName.Query("Nodes='" & data("Nodes") & "'","")

if not rstmp.eof then 'there is record in the detail table

xt.assign record("TableName_custom"),""

else

xt.assign record("TableName_custom"), "not completed"

end if

rstmp.close

set rstmp=nothing