Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pagino

  1. pagino

    keyword search in dynamic stored procedure

    FYI .. print out of query which is working, now I'll move into making it better: Select a.jobId, a.jobTitle, a.jobShortDescription, a.jobTypeId, a.jobCategoryId, a.employerId, a.createDate, b.city, b.stateId, b.province, b.countryId, c.stateAbreviation, d.countryAbreviation, e.employerName...
  2. pagino

    keyword search in dynamic stored procedure

    Bamm .. Got it work with freetext .. Thanks a lot guys .. I learned a bunch here .. Cheers
  3. pagino

    keyword search in dynamic stored procedure

    Jay .. If I take the double quotes out I get the following error: Server: Msg 7631, Level 15, State 1, Line 1 Syntax error occurred near 'developer'. Expected ''''' in search condition 'painter developer'.
  4. pagino

    keyword search in dynamic stored procedure

    Jay .. You are seeing wildcards in the other search values because the user didn't select or enter anything into the form input, so I'm just getting all records .. I do plan on going back in cleaning it up a lot .. but at this time I'm mostly concerned with the full text search not giving me the...
  5. pagino

    keyword search in dynamic stored procedure

    Ok .. I got the error to go away, and the keyWords I'm passing are: painter developer I thought that for full text search, it would go and find all records that have either one of those two keyWords, I'm I wrong about this ? CODE: Select a.jobId, a.jobTitle, a.jobShortDescription, a.jobTypeId...
  6. pagino

    keyword search in dynamic stored procedure

    Ok .. so there actually was no problem with the statement. However if more than one word exists in the parameter of @keyWords, then I get the following error:: @keyWords = Developer Cook Error: Syntax error occurred near 'Cook'. Expected ''''' in search condition 'Developer Cook'.
  7. pagino

    keyword search in dynamic stored procedure

    Gang .. sorry to bother again .. I've tried the following in my dynamic stored proc:: Changed line that currently reads: set @sql = @sql + 'AND a.keyWords like' + char(10) + '''' + '%' + @keyWords + '%' + '''' + char(10) To: set @sql = @sql + 'AND contains (a.jobTitle,' + char(10) + '''' +...
  8. pagino

    keyword search in dynamic stored procedure

    Ok guys .. Got my full text search catalog created, I called it SearchKeyWords .. Any tips on how to go about calling it from within my dynamic stored proc ?
  9. pagino

    keyword search in dynamic stored procedure

    Excellent .. This is exactly what I needed .. I'll make my case to get full text search going in here .. Thanks a lot for all the help ..
  10. pagino

    keyword search in dynamic stored procedure

    Thanks Jay .. I'm new to Full Text Searches .. so pls forgive me as I may seem disoriented ... anyhow, the stored procedure you see here takes data from a form which sends more than one parameter per request to the stored proc and those parameters can be integers and varchars. My question is...
  11. pagino

    keyword search in dynamic stored procedure

    Thanks Denny .. I'm reading through all the documents right now, but I'm yet to find a case that would apply it in a dynamic stored procedure however .. do you have any examples ..
  12. pagino

    keyword search in dynamic stored procedure

    Hello Gang .. I have a dynamic stored procedure which needs to be able to process as part of it's search a form field which may contain several words seperated by a space. ie: earth diamonds brazil ocean My dynamic stored procedure works great, right now the parameter containing the form input...
See more

Part and Inventory Search

Back
Top