Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







HOW!!! Do You Use Paramaters With FormsOf(INFLECTIONAL, @xxx)


I'm having trouble using paramaters in a full-text search with FormsOf(INFLECTIONAL:

DECLARE @SearchWord nvarchar(4000)

SET @SearchWord = 'tax'

SELECT listing_id, RANK, name, address, city, zip, heading, phone

FROM listings a,

FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, @SearchWord')

WHERE [KEY] = a.listing_id

ORDER BY RANK DESC, name



This returns no results. It treats the paramater as a NULL value.  But this...





SELECT listing_id, RANK, name, address, city, zip, heading, phone

FROM listings a,

FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, tax')

WHERE [KEY] = a.listing_id

ORDER BY RANK DESC, name



returns over 500 results.  I've been banging my head against this for 2+hours.  Google has been no help as every example shows the result hard-coded in like the second example.

PLEASE HELP!!!!!!



????????


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
SQL Sever 2005 - Full Text FormsOf Inflectional
We have 2 SQL Server 2005 machines. One has the CTP version installed,the other is the RTM.When running the query below, results are returned for the CTP versionbut not the RTM version.select * from table t1inner join containstable(table, column, 'formsof(inflectional,''bücher'')') t2on t1.[id] = t2.[key]I have checked that the same data is present in the tables on bothmachines and also that the FTI has been fully populated with a statusof "idle".Please note that the word used "bücher" is a German word and shouldreturn "buch" as a match.Is this a bug with the RTM version of SQL Server 2005??

View Replies !   View Related
Query Help: JOIN ON CONTAINS With FORMSOF
Hi,I have been able to JOIN ON CONTAINS(column, 'whatever'), but can't seem toget the syntax right to join on one field containing a related field.The query below is what I am working with... As written, everything insidethe single quotes is interpreted as a literal string. I.e. "FormsOf" doesn'tact as a function, but just a bunch of letters. Any ideas?Thanks!SELECT 'Dolch' AS[List Name], dbo.Dolch.vchWordFROM dbo.Dolch LEFT OUTER JOINdbo.CombinedLexicons ONCONTAINS(dbo.Dolch.vchWord, 'FORMSOF(INFLECTIONAL,dbo.CombinedLexicons.vchWord)')WHERE (dbo.CombinedLexicons.vchWord IS NULL)

View Replies !   View Related
This May Be A Tough One: Contains With Inflectional And NOT Logic...Can It Be Done?
Thank you in advance!
 
I know from other posts that this works:
CONTAINS(column, 'formsof(inflectional,sport) AND formsof(inflectional,award)'
 
But I have an advanced googlesque search that includes "Without the Words:". I want to include inflectionals in the list of words to be omitted. Can this be done?
 
So far I have not had any success with:
'NOT(formsof(inflectional,sport)) AND NOT(formsof(inflectional, award))'
 
Any help would be greatly appreciated!

View Replies !   View Related
Concatenate String And Pass To FORMSOF?
The following query works perfectly (returning all words on a list called"Dolch" that do not contain a form of "doing"):SELECT 'Dolch' AS[List Name], dbo.Dolch.vchWordFROM dbo.Dolch LEFT OUTER JOINdbo.CombinedLexicons ON CONTAINS(dbo.Dolch.vchWord,'FORMSOF(INFLECTIONAL, "doing")')WHERE (dbo.CombinedLexicons.vchWord IS NULL)However, what I really want to do requires me to piece two strings together,resulting in a word like "doing". Any time I try to concatinate strings toget this parameter, I get an error.For example:SELECT 'Dolch' AS[List Name], dbo.Dolch.vchWordFROM dbo.Dolch LEFT OUTER JOINdbo.CombinedLexicons ON CONTAINS(dbo.Dolch.vchWord,'FORMSOF(INFLECTIONAL, "do' + 'ing")')WHERE (dbo.CombinedLexicons.vchWord IS NULL)I have also tried using & (as in "do' & 'ing") and various forms of singleand double quotes. Does anyone know a combination that will work?FYI, in case this query looks goofy because of the unused "CombinedLexicons"table, it is because the end result should be a working form of thefollowing...Figuring out the string concatination is just a step toward this goal:SELECT 'Dolch' AS[List Name], dbo.Dolch.vchWordFROM dbo.Dolch LEFT OUTER JOINdbo.CombinedLexicons ON CONTAINS(dbo.Dolch.vchWord,'FORMSOF(INFLECTIONAL, ' + dbo.CombinedLexicons.vchWord + ')')WHERE (dbo.CombinedLexicons.vchWord IS NULL)Thanks!

View Replies !   View Related
Using Contains To Find Inflectional Variations Of Multi Words With AND Logic
what if you want to search with AND logic using the FORMSOF(inflectional,...) methodology.

if my search phrase is "sport award" I can easily do an OR search using the following in my where clause:
CONTAINS(Colname,'formsof(INFLECTIONAL,sport,award).
but the and is far more tricky....

does anyone know how to do this without having multiple Contains statements (which greatly increases overhead)?

I know that I can use AND in a straight contains like so:
CONTANS(column, '"sport" AND "award"') but this does not allow me to explore inflectional variations on the words...

nesting multiple FORMSOF's doesn't seem to work either like so:
contains(column,'"formsof(inflectional,sport)"' AND 'formsof(inflectional,award)"')

anyone else found how to do this?

View Replies !   View Related
User Input - SQL Paramaters
 Hi, Just wondering if I could make sure that "hackers" don't tamper with my querystring - which is a parameter for a SQL query. i.e...  Dim ListOfValues as string = request.querystring("listOfValues")

'Output would be this: 324234,5445,554654,45632,SQL command :  Delete From table where product_id IN (@ListOfValues)

cmd.paramaters.addwithvalue("@ListOfValues", ListOfValues ) 



How can I validate it so that hackers can't add any characters other than 'numbers' and ' , ' to the sql parameter? I have tried to tryparse the 'ListOfValues ' as an integer - by replacing "," with "" but an integer overflow occured. Any questions or ideas? Thanks   

View Replies !   View Related
A DOS Question! (about Aspnet_regsql.exe With Paramaters)
I need to setup some asp security databases and I have seen several sets of instructions. Some say "Navigate to C:WINDOWSMicrosoft.NETFrameworkv2.0.50727" and some say at the "asp command box". I do know that the directory & file exists on my machine. I have run aspnet_regsql.exe to configure my local server. I now need to run it to configure my web host SQL Server 2005 and that requires some paramaters like "aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name]". I am old and started before windows. I know DOS. But obviously not well enough.
How do you "Navigate to C:WINDOWSMicrosoft.NETFrameworkv2.0.50727"?
If I say "CDWINDOWS", it works.
When I am at the "C:WINDOWS>" prompt and say "CD Microsoft.NET" it says "invalid directory"
When I am at the "C:>" prompt and say "CDWINDOWSMicrosoft.NET" it says "invalid directory"
When I am at the "C:>" prompt and say "CDWINDOWSMicros~1" it says "invalid directory"
Thanks for your help. John Brown

View Replies !   View Related
Writing SQL Searchs Using LIKE And @paramaters
I'm writing a search query in TSQL for MS SQL. Here is my code:


SELECT a.*, b.username, c.categoryname FROM
video a
inner join
user b
on
a.userid = b.userid
inner join
video_category c
on
a.categoryId = c.categoryid
where
a.videotitle like '%@SearchText%'
OR
a.description like '%@SearchText%'



This returns no results, but wheN I replace the '%@SearchText%' with my search text inplace of the @SearchText it returns retuls. I have a feelign I am passing the params to the LIKE clause incorrectly. Any suggestions?

Thanks,

-- shawn

View Replies !   View Related
How To Search A Database By Paramaters
Hi,

Does anyone know how i go about writing a search query using paramaters, ive been using this as my template:
Select Distinct Recipedata.Name, Ingredients.Ingredient, Directions.Directions
from Recipedata,Ingredients,Directions
Where Ingredients.Ingredient Like '%Chicken%' and

RecipeData.RecipeID = Ingredients.RecipeID and Ingredients.RecipeID = Directions.RecipeID;

Problem is now that i want to use paramters instead of hard coded values as this is for a user. How do i go about this? This database has a VB2k5 front end for the desktop and PDA(and no the target PDA is not web enabled so web servcies arent available to me).

 

Thanks Much

 

 

 

View Replies !   View Related
Evaluating/Validating Paramaters In A SqlDataSource
I want to do some error checking on the parameters found in a SQLDataSource before I run the insert.  The problem is these are ControlParameters and I want to do this dynamically so I can't just call the Control.Text property and grab its value. So how can I get access to what the ControlParameter evaluates to?
Secondly, is there a way to access what the update parameters evaluate to in order to check them before they're inserted - if so how do I get access to these?
Here's an example of one of the data sources i'm using:<asp:SqlDataSource ID="sqlContact" runat="server" ConnectionString="<%$ ConnectionStrings:strConn %>"
SelectCommand="SELECT [ContactID], [FirstName], [LastName], , [Address], [Phone], [Grade], [Contacted], [ListServe] FROM [Contact]"
UpdateCommand="UPDATE Contact SET FirstName = @FirstName, LastName = @LastName, Email = @Email, Address = @Address, Phone = @Phone, Grade = @Grade WHERE ContactID = @ContactID"
DeleteCommand="DELETE FROM [Contact] WHERE ContactID = @ContactID"
InsertCommand="INSERT INTO [Contact] ([FirstName],[LastName],,[Address],[Phone],[Grade],[Contacted],[ListServe]) VALUES (@FirstName,@LastName,@Email,@Address,@Phone,@Grade,0,0)">
<UpdateParameters>
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="LastName" Type="String" />
<asp:Parameter Name="Email" Type="String" />
<asp:Parameter Name="Address" Type="String" />
<asp:Parameter Name="Phone" Type="String" />
<asp:Parameter Name="Grade" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:ControlParameter Name="FirstName" Type="String" ControlID="txtContactFirst" PropertyName="Text" />
<asp:ControlParameter Name="LastName" Type="String" ControlID="txtContactLast" PropertyName="Text" />
<asp:ControlParameter Name="Email" Type="String" ControlID="txtContactEmail" PropertyName="Text" />
<asp:ControlParameter Name="Address" Type="String" ControlID="txtContactAddress" PropertyName="Text" />
<asp:ControlParameter Name="Phone" Type="String" ControlID="txtContactPhone" PropertyName="Text" />
<asp:ControlParameter Name="Grade" Type="String" ControlID="ddlContactGrade" PropertyName="SelectedValue" />
</InsertParameters>
</asp:SqlDataSource>
 An Event is fired when I click add on a button which looks similar to this:
//Add btnAddContact_Clickprotected void btnAddContact_Click(object sender, EventArgs e)
{
InsertRow(sqlContact);
}The InsertRow() function is then what i'm using to evaluate the values...  So how can get the values those controlparameters actually are in order to evaluate them before I actually insert.  Or is there a better way to do it?

View Replies !   View Related
Output Paramaters Are Not Getting Execute SQL Task In DTS
Hi,
I have two SQL task editor.
I'm inserting a row in task editor 1 and getting a output parameter GvBatchDate.
I'm getting 3 input parameters inclduing GvBatchDate inserting into task editor 2. It is getting input values and iserting correctly. I'm getting another 4 output parameters from task editor 2 and those passing into Transform Data Task and Activex script.
I'm mapping All those 4 parameters are correctly in row value but still those not passing into Transform Data Task and Activex script.
Am I doing wrong anything here?. The funny thing is that I have the same kind of logic in SSIS and it is working good but not working correctly in DTS.

Could anybody provide your opinion for my issue?.

I realy appreciate your help.

Thanks,

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved