I have a contact form on a web site with a submit button. The fields are validated by a js file that returns true if no errors or false if errors to the form. If no errors, I need to call an asp file which will just create and send an email that contains the info from the contact form...
I have a table as such:
ID cost
1 654.77
2 953.54
3 345.98
...
for each of these ID's I have in a child table a list of percentages that equal 100 for each ID: (the percent has 4 dec places but here putting 2 for symplicity.
ID percent
1 .50
1...
I have a stored proc in sql server 2000. I need to set a variable using a dynamic query:
set @SQLstring = 'select ' + @x1 + ' from tblAssettype where assettypeid = ' + cast(@atype as varchar(18))
EXEC(@SQLstring)
This works fine and returns a string. However, I have to run this query...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.