romax
Posts: 5
|
| Posted: 09/20/2004, 8:10 AM |
|
I am using ASP with Oracle and my searches are obvisously case sensitive. However I can not figure out where to pu the upper syntax to change my sql query.
Do I need to change my data source to SQL from Table? Or can I edit the following code which contains the where clause.
Method = IIf(FormSubmitted, ccsPost, ccsGet)
Set s_QUESTION = CCCreateControl(ccsTextBox, "s_QUESTION", "s_QUESTION", ccsText, Empty, CCGetRequestParam("s_QUESTION", Method))
Set s_ANSWER = CCCreateControl(ccsTextBox, "s_ANSWER", "s_ANSWER", ccsText, Empty, CCGetRequestParam("s_ANSWER", Method))
Set Button_DoSearch = CCCreateButton("Button_DoSearch")
Set ValidatingControls = new clsControls
ValidatingControls.addControls Array(s_QUESTION, s_ANSWER)
Or is it actually in this chunk?
With WhereParameters
Set .Connection = Connection
Set .ParameterSources = Parameters
Set .DataSource = Me
.AddParameter 1, "urls_QUESTION", ccsText, Empty, Empty, Empty, False
.AddParameter 2, "urls_ANSWER", ccsText, Empty, Empty, Empty, False
.Criterion(1) = .Operation(opContains, False, "QUESTION.QUESTION", .getParamByID(1))
.Criterion(2) = .Operation(opContains, False, "QUESTION.ANSWER", .getParamByID(2))
.AssembledWhere = .opAND(False, .Criterion(1), .Criterion(2))
WhereParams = .AssembledWhere
|
