paul,
this is working fine. but ...
In the insert form i already have a submit button
so can't have 2 submit button

how can solved this in a way that should or not with a button
must I have another form or can I do this in one form but than how?

please advise
kisoen


"Paul Whitham TMM" <paul@valleybiz.net> wrote in message
news:cur7v2$ctv$1@forums.macromedia.com...
>I would try to use a Trim command on the input field to remove any space
> that may have been passed into it as your SQL statement will be trying to
> match on the spaces as well. Something like
>
> name ' varuser'
> value 1
> run time value trim(request("requestor" ))
>
>
>
>
> --
> Regards
>
> Paul Whitham
> Macromedia Certified Professional for Dreamweaver MX2004
> Valleybiz Internet Design
> [url]www.valleybiz.net[/url]
>
> Team Macromedia Volunteer for Ultradev/Dreamweaver MX
> [url]www.macromedia.com/support/forums/team_macromedia[/url]
>
> "r.kisoenpersad" <r.kisoenpersad@chello.nl> wrote in message
> news:cuohik$673$1@forums.macromedia.com...
>> I have an Insert Form. made via DMX. Building a helpdesk website. (trying
> ;)
>> My question is
>> I have a listbox in the form where you can select a particular user.
>> (Call
>> registration)
>> When selecting the user I want that beneath the page the records must be
>> shown where the particular for the pas month is registered. (like a short
>> overview want we have registered for this user).
>>
>> Want I did..
>> made a recordset (POST)
>> inserting beneath the page the records to be shown
>>
>> LISTBOX = name
>> my query is like this
>>
>> SELECT fields
>> FROM table
>> WHERE UserID = 'name'
>>
>> Set the runtime value of name to, Request.Form("Name")
>> insert a button
>> NOW I have 2 button (this can't work he!)
>> anyhow
>>
>> in the result page that is pop up (not nice but workable) there the
>> result
>> is displayed
>> but only the query is not good perhaps you can help me with this one
>>
>> SELECT Call.CallID, Call.IntakeDate, Call.IntakeBy, Call.SystemID,
>> Call.ShortDescription, Tblusers.username FROM Call INNER JOIN Tblusers
>> ON
>> Call.CustomerName = Tblusers.username where tblusers.username = 'varuser'
>>
>> name
>> ' varuser'
>>
>> value
>> 1
>> run time value
>> request("requestor" )' name of the listbox
>>
>> this is working fine when I do LIKE in the query
>>
>> like '%varuser%' than i see some output besides the listbox user
>> soooo is something wrong with the query or....
>>
>> thx Kisoen
>>
>>
>
>