parikaa
asked on
Coldfusion query result variable into innerHTML variable
How can I store my query result into an innerHTML variable?
<cfstoredproc procedure="PK.SP_GET_INFO" datasource="dsn">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" value="#session.mySession# ">
<cfprocresult name="resultSet">
</cfstoredproc>
<cfset variables.firstname = resultSet.firstname>
txt_firstname.innerHTML = variables.firstname;
Firstname: <span id="txt_firstname"></span>
<cfstoredproc procedure="PK.SP_GET_INFO"
<cfprocparam type="in" cfsqltype="cf_sql_varchar"
<cfprocresult name="resultSet">
</cfstoredproc>
<cfset variables.firstname = resultSet.firstname>
txt_firstname.innerHTML = variables.firstname;
Firstname: <span id="txt_firstname"></span>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.