Hello;
I am saving off my queries to a database table. However, everytime they get saved off, the table name in the From statement always shows up as [Temp] not matter what. Got any solutions for this?
Thanks,
Ed
protected
void ButtonSaveQuery_Click(object sender, EventArgs e)
Session.Add(
"filteredquery", AdHoc1.FilteredSQL);
Response.Write(
"<SCRIPT language=javascript>var w=window.open('saveQuery.aspx','SaveQueries','height=800,width=800,status=yes,toolbar=no,menubar=no,location=no, scrollbars=yes, resizeable=yes');</SCRIPT>");
}
Query is as follows:
"SELECT [DateofContact], [FVSPA_Age], [GenderDescription], [IssueDescription], [locationDescription], [ParticipantTypeDescription], [programID], [programName], [sumAmericanIndian], [sumAsian], [sumBlack], [sumCaucasian], [sumHispanic], [sumNativeAlaskan], [sumPacificIslander], [sumUnknown], [VAWA_AGE] FROM [Temp] WHERE ((([programID] = 'AFS'))) ORDER BY [programID]"
