Thanks for the previous answers, but I'm still not getting things done.
Versions;
4d 2004.1
A4D 3.0 gave problems with the former (even though I added a rule
QUERY([Component];[Component]DNS="@";*) And ended with
QUERY([Component];&;[Component]DNS="@"))
A4D 3.01b7 solved this problem
But now I've got a new one, for some reason it often results in only one
or none records (even though muliple records should be the result). It
looks like the formvariables ain't cleared the right way or that the query
stays in the memory.
allthough session{"sv_sAction"} does work if(defined(_form{"cbxMType"}))
results in this error
Active4D error
Expecting a variable.
if(defined(_form{"cbxMType"}))
(_form = red and bold)
Any way to work around these two problems?
Yours sincerely,
Michael Zandstra.
On Vr, 12 augustus, 2005 12:47 pm, Aparajita Fishman zei:
>> - First, I select all record from the table Components
>> - Then I check for an session variable called sv_sAction to be set at
>> "SearchComp".
>> - If this is set, I run queries if certain fields where filled in by a
>> form with the post method.
>> - Then, whatever I do, I allways get
>>
>> Active4D error
>> Expecting a '<=' or a '#' or a '>='.
>> QUERY([User];[User]Code=Num(get session("lWebUserID")))
>
> First of all, and I would like to remind everyone of this, please
> give full configuration information of your setup (4D/A4D version and
> OS) whenever you ask a question. It makes a difference.
>
>
>> My code that I described earlier;
>> `Let's check if the user had searched for something specific
>> ALL RECORDS([Component])
>> if (get session("sv_sAction")="SearchComp")
>> if(defined($fsDNS))
>> QUERY([Component];&;[Component]DNS="@"+String($fsDNS)+"@";*)
>> end if
>> if(defined($cbxMType))
>> if(Not(Num($cbxMType)=0))
>> QUERY([Component];&;[Component]MainSystemTypeID=Num
>> ($cbxMType);*)
>> end if
>> end if
>> end if
>
> Where are you actually closing the query on [Component]? Both of the
> queries above end with *, so you have to issue one more query on
> [Component] without a *.
>
> A few stylistic notes:
>
> - It is easier (and preferred) to use session{"sv_sAction"} rather
> than get session("sv_sAction").
>
> - I see you are using auto-created form variables. I recommend
> against using them. It is much better to use _form{"cbxMType"} and so
> on.
>
> Regards,
>
> Aparajita
> Victory-Heart Productions
> www.aparajitaworld.com
>
> "If you dare to fail, you are bound to succeed."
> - Sri Chinmoy | www.srichinmoylibrary.com
>
> _______________________________________________
> Active4D-dev mailing list
> Active4D-dev@aparajitaworld.com
> http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
> Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
>
>
_______________________________________________
Active4D-dev mailing list
Active4D-dev@aparajitaworld.com
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
