SQL halp plxplx

Lamil · 05-16-2008, 01:25 PM

something here is messed up.

It's not pulling any data so im getting table0 not found ect.

I think its something with the format of the sql but i can't see it =\

Quote:

/// <summary>
/// StreetRangeSearch
/// </summary>
private void StreetRangeSearch()
{

this.SearchSQLString = @" SELECT
[StreetName],
[SRange],
[ERange],
[City],
[State],
[Zip],
[County],
[WardE],
[WardO],
[RowRank] from (
SELECT distinct
[tblStreetRanges].[StreetName],
[tblStreetRanges].[SRange],
[tblStreetRanges].[ERange],
[tblStreetRanges].[City],
[tblStreetRanges].[State],
[tblStreetRanges].[Zip],
[tblStreetRanges].[County],
[tblStreetRanges].[WardE],
[tblStreetRanges].[WardO]
";

this.WhereString = " WHERE tblStreetRanges.DepartmentId = '" + CurrentMemberStore.DepartmentId + "' ";

this.FromString = @" FROM tblStreetRanges with (NoLock) ";

//Add in any columns that need to be changed to public access.
//this.PublicWebPath = new string[] { "DocumentThumbnailLink" };

DataSet dsSQLSearchColumns = new DataSet();

DataTable dtSQLSearchColumns = BuildSearchColumnsTable();

Johnathon · 05-16-2008, 01:45 PM

Quote:

Originally Posted by Lamil

something here is messed up.

It's not pulling any data so im getting table0 not found ect.

I think its something with the format of the sql but i can't see it =\

PHP Code:


			
/// <summary>

/// StreetRangeSearch

/// </summary>

private void StreetRangeSearch()

{



this.SearchSQLString = @" SELECT

[StreetName],

[SRange],

[ERange],

[City],

[State],

[Zip],

[County],

[WardE],

[WardO],

[RowRank] from ( <------- HERE IS THE START ONE

SELECT distinct

[tblStreetRanges].[StreetName],

[tblStreetRanges].[SRange],

[tblStreetRanges].[ERange],

[tblStreetRanges].[City],

[tblStreetRanges].[State],

[tblStreetRanges].[Zip],

[tblStreetRanges].[County],

[tblStreetRanges].[WardE],

[tblStreetRanges].[WardO]

";





this.WhereString = " WHERE tblStreetRanges.DepartmentId = '" + CurrentMemberStore.DepartmentId + "' ";



this.FromString = @" FROM tblStreetRanges with (NoLock) ";







//Add in any columns that need to be changed to public access.

//this.PublicWebPath = new string[] { "DocumentThumbnailLink" };



DataSet dsSQLSearchColumns = new DataSet();



DataTable dtSQLSearchColumns = BuildSearchColumnsTable();

Your missing the ending )

Also, its seems that you screwed up a couple places, or i don't know what the hell your trying to do.

stryph · 05-16-2008, 01:47 PM

Check the DataSet. Doesn't it tell you when you get the error on what line the error is occuring?

i.e. System.Data.DataTableCollection.get_Item(Int32 index) +107

Lamil · 05-16-2008, 03:33 PM

i figured it out. it wanted a date. and i didnt have one. and i forgot to say somewhere else that im not sorting by a date

changed a " " to a "-1" and its all betterrs