SQL to insert data (Syntax)
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=left
row = '4'
iconorder = '99'
superuseravailable = '1'
adminavailable = '1'
image = '<img src="../Images/iconusersgu
Linktoleftframe = 'BT/Basictraining.asp'
What I need is the full sql to insert all this values :)
Thx for the help :)
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=left
row = '4'
iconorder = '99'
superuseravailable = '1'
adminavailable = '1'
image = '<img src="../Images/iconusersgu
Linktoleftframe = 'BT/Basictraining.asp'
What I need is the full sql to insert all this values :)
Thx for the help :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am trying the following:
---
INSERT INTO HomepageIcons
( Firmid ,
IconName ,
Linkto ,
row ,
iconorder ,
superuseravailable ,
adminavailable ,
image ,
Linktoleftframe
)
VALUES ( '1' ,
'Basic Training' ,
'frames.asp?leftframe=left
'4' ,
'99' ,
'1' ,
'1' ,
'<img src='../Images/iconusersgu
'BT/Basictraining.asp'
)
---
I get an error on the code that has the ' it breaks the code, how can I insert a : ' ?
line: '<img src='../Images/iconusersgu
---
INSERT INTO HomepageIcons
( Firmid ,
IconName ,
Linkto ,
row ,
iconorder ,
superuseravailable ,
adminavailable ,
image ,
Linktoleftframe
)
VALUES ( '1' ,
'Basic Training' ,
'frames.asp?leftframe=left
'4' ,
'99' ,
'1' ,
'1' ,
'<img src='../Images/iconusersgu
'BT/Basictraining.asp'
)
---
I get an error on the code that has the ' it breaks the code, how can I insert a : ' ?
line: '<img src='../Images/iconusersgu
ASKER
Tired this but didn't work:
'<img src='''../Images/iconusers
Tried this didn't work:
'''<img src='../Images/iconusersgu
'<img src='''../Images/iconusers
Tried this didn't work:
'''<img src='../Images/iconusersgu
ASKER
:)
if you use the code examples i gave, you do not need to worry about single quotes or escaping any other charactors
ASKER