Click here to Skip to main content
16,012,223 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: have a string value, need its related integer value Pin
Paul Riley4-Sep-02 6:53
Paul Riley4-Sep-02 6:53 
GeneralBrowser DOM references Pin
alex.barylski4-Sep-02 0:28
alex.barylski4-Sep-02 0:28 
GeneralRe: Browser DOM references Pin
Jeremy Falcon5-Sep-02 3:53
professionalJeremy Falcon5-Sep-02 3:53 
GeneralIgnore my last message read me instead Pin
alex.barylski4-Sep-02 0:25
alex.barylski4-Sep-02 0:25 
GeneralRe: Ignore my last message read me instead Pin
Not Active5-Sep-02 7:52
mentorNot Active5-Sep-02 7:52 
QuestionRetrieving the next element...??? Pin
alex.barylski3-Sep-02 23:40
alex.barylski3-Sep-02 23:40 
Generalonline billing for students.... Pin
drmzunlimited3-Sep-02 11:12
drmzunlimited3-Sep-02 11:12 
Generalderiving an integer value Pin
mcm3-Sep-02 6:08
mcm3-Sep-02 6:08 
my tables are:
skills: skill(str), skillID(autonumber))
subcategory: subcategory(str), subcategoryid(autonumber), skillID(int)

i am obtaining the value for skill in the string type via a text box(strSkill). however, i need to save this value to the subcategory table as its ID number (ie as an interger value). i am trying to use a SQL statement to derive its related ID, but am failing to do so. where is the problem?

dim sql
sql = "SELECT DISTINCT SkillID FROM Skills WHERE (((Skills.Skill)='" & replace(strSkill,"'","''") & "'))"
Set RS = objConn.Execute(SQL)


If Not bolAlreadyExists Then

RS.AddNew
'adding the new subskill to the table

RS("SubCategory") = Request.Form("SubCategory")
RS("SkillID") = Request.Form("Skills")
'closing the recordset and connection object
RS.Update
RS.Close

thank you!Smile | :)
GeneralRe: deriving an integer value Pin
Nick Parker3-Sep-02 8:10
protectorNick Parker3-Sep-02 8:10 
Generalpassing values when redirecting Pin
mcm3-Sep-02 5:06
mcm3-Sep-02 5:06 
GeneralRe: passing values when redirecting Pin
Paul Riley3-Sep-02 5:41
Paul Riley3-Sep-02 5:41 
GeneralRe: passing values when redirecting Pin
Nick Parker3-Sep-02 8:14
protectorNick Parker3-Sep-02 8:14 
GeneralTemplateColumn:DropDownList Edit Selected Item Pin
MStanbrook2-Sep-02 15:11
MStanbrook2-Sep-02 15:11 
GeneralRe: TemplateColumn:DropDownList Edit Selected Item Pin
Todd Smith2-Sep-02 15:36
Todd Smith2-Sep-02 15:36 
GeneralRe: TemplateColumn:DropDownList Edit Selected Item Pin
MStanbrook2-Sep-02 15:50
MStanbrook2-Sep-02 15:50 
GeneralMy Evil XSLT and ASP.NET Code (long) Pin
Domenic Denicola2-Sep-02 7:12
Domenic Denicola2-Sep-02 7:12 
GeneralRe: My Evil XSLT and ASP.NET Code (long) Pin
Domenic Denicola2-Sep-02 8:29
Domenic Denicola2-Sep-02 8:29 
Generalredirecting a user based on combo-box selection Pin
mcm2-Sep-02 3:59
mcm2-Sep-02 3:59 
GeneralRe: redirecting a user based on combo-box selection Pin
Paul Watson2-Sep-02 5:33
sitebuilderPaul Watson2-Sep-02 5:33 
GeneralRe: redirecting a user based on combo-box selection Pin
mcm2-Sep-02 5:54
mcm2-Sep-02 5:54 
GeneralRe: redirecting a user based on combo-box selection Pin
Paul Watson2-Sep-02 5:59
sitebuilderPaul Watson2-Sep-02 5:59 
GeneralDHTML collapsable tables Pin
benjymous1-Sep-02 23:54
benjymous1-Sep-02 23:54 
GeneralRe: DHTML collapsable tables Pin
Paul Watson2-Sep-02 5:44
sitebuilderPaul Watson2-Sep-02 5:44 
GeneralRe: DHTML collapsable tables Pin
benjymous2-Sep-02 6:23
benjymous2-Sep-02 6:23 
GeneralRe: DHTML collapsable tables Pin
Anonymous3-Sep-02 1:59
Anonymous3-Sep-02 1:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.