I need to insert data to table: HomepageIcons
The problem is with the first item ("FirmId") , which its value comes from the result of the following sql:
Select firmid from HomepageIcons where IconName = 'Cases' --- this value should be inserted in the table row along with the rest of the values as listed below (note that 'image' value has quotes in there, is the syntax right ?
Firmid = ? (This is the value that comes from the result of the sql above)
IconName = 'Basic Training'
Linkto = 'frames.asp?leftframe=leftframe.asp&mainframe=BT/Basictraining.asp'
row = '4'
iconorder = '99'
superuseravailable = '1'
adminavailable = '1'
image = '<img src="../Images/iconusersguide.gif" border=0>'
Linktoleftframe = 'BT/Basictraining.asp'
What I need is the full sql to insert all this values :)
Thx for the help :)