TOTALLY stuck with Dynamic List/Menus ASP/VB...please help!

Report · Jun 17, 2006

Hi. I've got the Dynamic Drop-Down extension from WebAssist and I am using
ASP/VB.

Here are my tables:

Countries
countryID
countryname

Regions
regionID
countryID
regionname
operatingarea

I have a customer registration form that asks the customer to select a
country. When they select a country this changes the region drop down to
only display the regions in that country....all that is working fine.
Great!

However....I need to also save the operatingarea, for the region they
choose, in a hidden field so that I can also INSERT this to the database as
part of the customers registration.

I am totally stuck at this point and WebAssist are telling me that their
extension doesn't handle this, period.

How do I get the operating area, associated with the regional choice by the
user, to be inserted into the hidden field? Is this even possible within
one page, or am I going to have to create a page in between the initial form
page and the success page? I really dislike those "middle man" pages, or a
0 second redirect page, and want to avoid that if at all possible.

Hope someone can point me in the right direction.
Thanks in advance.
Nath.

Report · Jun 17, 2006

On 17 Jun 2006 in macromedia.dreamweaver.appdev, Nathon Jones wrote:

> However....I need to also save the operatingarea, for the region
> they choose, in a hidden field so that I can also INSERT this to the
> database as part of the customers registration.
[snip]
> How do I get the operating area, associated with the regional choice
> by the user, to be inserted into the hidden field?

Why do it clientside at all? Just set it up when you validate and
process the data and before you insert it, something like (pseudocode):

select case region {
case 1-10 {
operatingarea = 1
}
case 11-20 {
operatingarea = 2
}
...
} // end select case

VBScript SelectCase:

http://devguru.com/technologies/vbscript/14177.asp

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/email.php

Report · Jun 17, 2006

? :o(

Validate and process the data? Does that take place within the DW INSERT
behaviour?
The operating areas are text values, also.

Would appreciate any help you could offer to someone very new to all this.
Thanks.
Regards
Nath.

"Joe Makowiec" <makowiec@invalid.invalid> wrote in message
news:Xns97E554A9150E5makowiecatnycapdotrE@216.104.212.96...
> On 17 Jun 2006 in macromedia.dreamweaver.appdev, Nathon Jones wrote:
>
>> However....I need to also save the operatingarea, for the region
>> they choose, in a hidden field so that I can also INSERT this to the
>> database as part of the customers registration.
> [snip]
>> How do I get the operating area, associated with the regional choice
>> by the user, to be inserted into the hidden field?
>
> Why do it clientside at all? Just set it up when you validate and
> process the data and before you insert it, something like (pseudocode):
>
> select case region {
> case 1-10 {
> operatingarea = 1
> }
> case 11-20 {
> operatingarea = 2
> }
> ...
> } // end select case
>
> VBScript SelectCase:
>
> http://devguru.com/technologies/vbscript/14177.asp
>
> --
> Joe Makowiec
> http://makowiec.net/
> Email: http://makowiec.net/email.php

Report · Jun 19, 2006

Hi Nathan,

Did you try submitting a product support incident? Feel free to contact
me off list if you would like to discuss this further.

Regards,
Mark

Nathon Jones wrote:
> Hi. I've got the Dynamic Drop-Down extension from WebAssist and I am using
> ASP/VB.
>
> Here are my tables:
>
> Countries
> countryID
> countryname
>
> Regions
> regionID
> countryID
> regionname
> operatingarea
>
> I have a customer registration form that asks the customer to select a
> country. When they select a country this changes the region drop down to
> only display the regions in that country....all that is working fine.
> Great!
>
> However....I need to also save the operatingarea, for the region they
> choose, in a hidden field so that I can also INSERT this to the database as
> part of the customers registration.
>
> I am totally stuck at this point and WebAssist are telling me that their
> extension doesn't handle this, period.
>
> How do I get the operating area, associated with the regional choice by the
> user, to be inserted into the hidden field? Is this even possible within
> one page, or am I going to have to create a page in between the initial form
> page and the success page? I really dislike those "middle man" pages, or a
> 0 second redirect page, and want to avoid that if at all possible.
>
> Hope someone can point me in the right direction.
> Thanks in advance.
> Nath.
>
>

Report · Jun 19, 2006

Yes I did Mark and someone replied to say:
"There is nothing in Dynamic Dropdowns that will help you with this, so you
will have to account for it manually. "

There was also some advice about Concatination but I'm really not sure
that's what I need to do.

I'll add to the support incident I've submitted, in the hope that perhaps
this initial advice was not correct. Thank you.

Regards
nath.

"Mark Fletcher *WebAssist*" <mfletcher@webassist.com> wrote in message
news:e75kn6$s6p$1@forums.macromedia.com...
> Hi Nathan,
>
> Did you try submitting a product support incident? Feel free to contact
> me off list if you would like to discuss this further.
>
> Regards,
> Mark
>
>
>
>
> Nathon Jones wrote:
>> Hi. I've got the Dynamic Drop-Down extension from WebAssist and I am
>> using ASP/VB.
>>
>> Here are my tables:
>>
>> Countries
>> countryID
>> countryname
>>
>> Regions
>> regionID
>> countryID
>> regionname
>> operatingarea
>>
>> I have a customer registration form that asks the customer to select a
>> country. When they select a country this changes the region drop down to
>> only display the regions in that country....all that is working fine.
>> Great!
>>
>> However....I need to also save the operatingarea, for the region they
>> choose, in a hidden field so that I can also INSERT this to the database
>> as part of the customers registration.
>>
>> I am totally stuck at this point and WebAssist are telling me that their
>> extension doesn't handle this, period.
>>
>> How do I get the operating area, associated with the regional choice by
>> the user, to be inserted into the hidden field? Is this even possible
>> within one page, or am I going to have to create a page in between the
>> initial form page and the success page? I really dislike those "middle
>> man" pages, or a 0 second redirect page, and want to avoid that if at all
>> possible.
>>
>> Hope someone can point me in the right direction.
>> Thanks in advance.
>> Nath.

Report · Jun 19, 2006

Hi Nathan,

Let me know how you get on with the support incident.

Regards,
Mark

----------------------------------
Mark Fletcher
WebAssist.com
----------------------------------

Nathon Jones wrote:
> Yes I did Mark and someone replied to say:
> "There is nothing in Dynamic Dropdowns that will help you with this, so you
> will have to account for it manually. "
>
> There was also some advice about Concatination but I'm really not sure
> that's what I need to do.
>
> I'll add to the support incident I've submitted, in the hope that perhaps
> this initial advice was not correct. Thank you.
>
> Regards
> nath.
>
> "Mark Fletcher *WebAssist*" <mfletcher@webassist.com> wrote in message
> news:e75kn6$s6p$1@forums.macromedia.com...
>> Hi Nathan,
>>
>> Did you try submitting a product support incident? Feel free to contact
>> me off list if you would like to discuss this further.
>>
>> Regards,
>> Mark
>>
>>
>>
>>
>> Nathon Jones wrote:
>>> Hi. I've got the Dynamic Drop-Down extension from WebAssist and I am
>>> using ASP/VB.
>>>
>>> Here are my tables:
>>>
>>> Countries
>>> countryID
>>> countryname
>>>
>>> Regions
>>> regionID
>>> countryID
>>> regionname
>>> operatingarea
>>>
>>> I have a customer registration form that asks the customer to select a
>>> country. When they select a country this changes the region drop down to
>>> only display the regions in that country....all that is working fine.
>>> Great!
>>>
>>> However....I need to also save the operatingarea, for the region they
>>> choose, in a hidden field so that I can also INSERT this to the database
>>> as part of the customers registration.
>>>
>>> I am totally stuck at this point and WebAssist are telling me that their
>>> extension doesn't handle this, period.
>>>
>>> How do I get the operating area, associated with the regional choice by
>>> the user, to be inserted into the hidden field? Is this even possible
>>> within one page, or am I going to have to create a page in between the
>>> initial form page and the success page? I really dislike those "middle
>>> man" pages, or a 0 second redirect page, and want to avoid that if at all
>>> possible.
>>>
>>> Hope someone can point me in the right direction.
>>> Thanks in advance.
>>> Nath.
>
>

Report · Jun 19, 2006

Hi Mark,

I submitted a response this morning (it's now late afternoon here), but
haven't had a response yet. Interestingly, you've managed to respond in the
newsgroup here though, so should I stick with the support incidents or in
here? It seems that you respond more promptly in here! :o(

Regards
nath.

"Mark Fletcher *WebAssist*" <mfletcher@webassist.com> wrote in message
news:e768ri$olp$1@forums.macromedia.com...
> Hi Nathan,
>
> Let me know how you get on with the support incident.
>
> Regards,
> Mark
>
> ----------------------------------
> Mark Fletcher
> WebAssist.com
> ----------------------------------
>
>
> Nathon Jones wrote:
>> Yes I did Mark and someone replied to say:
>> "There is nothing in Dynamic Dropdowns that will help you with this, so
>> you will have to account for it manually. "
>>
>> There was also some advice about Concatination but I'm really not sure
>> that's what I need to do.
>>
>> I'll add to the support incident I've submitted, in the hope that perhaps
>> this initial advice was not correct. Thank you.
>>
>> Regards
>> nath.
>>
>> "Mark Fletcher *WebAssist*" <mfletcher@webassist.com> wrote in message
>> news:e75kn6$s6p$1@forums.macromedia.com...
>>> Hi Nathan,
>>>
>>> Did you try submitting a product support incident? Feel free to contact
>>> me off list if you would like to discuss this further.
>>>
>>> Regards,
>>> Mark
>>>
>>>
>>>
>>>
>>> Nathon Jones wrote:
>>>> Hi. I've got the Dynamic Drop-Down extension from WebAssist and I am
>>>> using ASP/VB.
>>>>
>>>> Here are my tables:
>>>>
>>>> Countries
>>>> countryID
>>>> countryname
>>>>
>>>> Regions
>>>> regionID
>>>> countryID
>>>> regionname
>>>> operatingarea
>>>>
>>>> I have a customer registration form that asks the customer to select a
>>>> country. When they select a country this changes the region drop down
>>>> to only display the regions in that country....all that is working
>>>> fine. Great!
>>>>
>>>> However....I need to also save the operatingarea, for the region they
>>>> choose, in a hidden field so that I can also INSERT this to the
>>>> database as part of the customers registration.
>>>>
>>>> I am totally stuck at this point and WebAssist are telling me that
>>>> their extension doesn't handle this, period.
>>>>
>>>> How do I get the operating area, associated with the regional choice by
>>>> the user, to be inserted into the hidden field? Is this even possible
>>>> within one page, or am I going to have to create a page in between the
>>>> initial form page and the success page? I really dislike those "middle
>>>> man" pages, or a 0 second redirect page, and want to avoid that if at
>>>> all possible.
>>>>
>>>> Hope someone can point me in the right direction.
>>>> Thanks in advance.
>>>> Nath.
>>

Report · Jun 19, 2006

Hi Nathan,

Please rest assured that you will receive a response from our support
department once the US office opens. I am based in the UK, hence the
reason I have replied promptly.

With regard to our Support Incident service we have a policy to provide
you with a response within 2-4 business hours. It is also a secure place
in which you can attach your files or upload your database if our
support team needs to look at that.

Let me know if you have any other questions.

Regards,
Mark

----------------------------------
Mark Fletcher
WebAssist.com
----------------------------------

Nathon Jones wrote:
> Hi Mark,
>
> I submitted a response this morning (it's now late afternoon here), but
> haven't had a response yet. Interestingly, you've managed to respond in the
> newsgroup here though, so should I stick with the support incidents or in
> here? It seems that you respond more promptly in here! :o(
>
> Regards
> nath.
>
> "Mark Fletcher *WebAssist*" <mfletcher@webassist.com> wrote in message
> news:e768ri$olp$1@forums.macromedia.com...
>> Hi Nathan,
>>
>> Let me know how you get on with the support incident.
>>
>> Regards,
>> Mark
>>
>> ----------------------------------
>> Mark Fletcher
>> WebAssist.com
>> ----------------------------------
>>
>>
>> Nathon Jones wrote:
>>> Yes I did Mark and someone replied to say:
>>> "There is nothing in Dynamic Dropdowns that will help you with this, so
>>> you will have to account for it manually. "
>>>
>>> There was also some advice about Concatination but I'm really not sure
>>> that's what I need to do.
>>>
>>> I'll add to the support incident I've submitted, in the hope that perhaps
>>> this initial advice was not correct. Thank you.
>>>
>>> Regards
>>> nath.
>>>
>>> "Mark Fletcher *WebAssist*" <mfletcher@webassist.com> wrote in message
>>> news:e75kn6$s6p$1@forums.macromedia.com...
>>>> Hi Nathan,
>>>>
>>>> Did you try submitting a product support incident? Feel free to contact
>>>> me off list if you would like to discuss this further.
>>>>
>>>> Regards,
>>>> Mark
>>>>
>>>>
>>>>
>>>>
>>>> Nathon Jones wrote:
>>>>> Hi. I've got the Dynamic Drop-Down extension from WebAssist and I am
>>>>> using ASP/VB.
>>>>>
>>>>> Here are my tables:
>>>>>
>>>>> Countries
>>>>> countryID
>>>>> countryname
>>>>>
>>>>> Regions
>>>>> regionID
>>>>> countryID
>>>>> regionname
>>>>> operatingarea
>>>>>
>>>>> I have a customer registration form that asks the customer to select a
>>>>> country. When they select a country this changes the region drop down
>>>>> to only display the regions in that country....all that is working
>>>>> fine. Great!
>>>>>
>>>>> However....I need to also save the operatingarea, for the region they
>>>>> choose, in a hidden field so that I can also INSERT this to the
>>>>> database as part of the customers registration.
>>>>>
>>>>> I am totally stuck at this point and WebAssist are telling me that
>>>>> their extension doesn't handle this, period.
>>>>>
>>>>> How do I get the operating area, associated with the regional choice by
>>>>> the user, to be inserted into the hidden field? Is this even possible
>>>>> within one page, or am I going to have to create a page in between the
>>>>> initial form page and the success page? I really dislike those "middle
>>>>> man" pages, or a 0 second redirect page, and want to avoid that if at
>>>>> all possible.
>>>>>
>>>>> Hope someone can point me in the right direction.
>>>>> Thanks in advance.
>>>>> Nath.
>

Report · Jun 19, 2006

I see. No problem Mark, I just found it odd that I was receiving responses
in here sooner than responses through the support incident route.
I look forward to hearing from the US office.

Regards
Nath.

"Mark Fletcher *WebAssist*" <mfletcher@webassist.com> wrote in message
news:e76cds$ap$1@forums.macromedia.com...
> Hi Nathan,
>
> Please rest assured that you will receive a response from our support
> department once the US office opens. I am based in the UK, hence the
> reason I have replied promptly.
>
> With regard to our Support Incident service we have a policy to provide
> you with a response within 2-4 business hours. It is also a secure place
> in which you can attach your files or upload your database if our support
> team needs to look at that.
>
> Let me know if you have any other questions.
>
> Regards,
> Mark
>
> ----------------------------------
> Mark Fletcher
> WebAssist.com
> ----------------------------------
>
>
>
> Nathon Jones wrote:
>> Hi Mark,
>>
>> I submitted a response this morning (it's now late afternoon here), but
>> haven't had a response yet. Interestingly, you've managed to respond in
>> the newsgroup here though, so should I stick with the support incidents
>> or in here? It seems that you respond more promptly in here! :o(
>>
>> Regards
>> nath.
>>
>> "Mark Fletcher *WebAssist*" <mfletcher@webassist.com> wrote in message
>> news:e768ri$olp$1@forums.macromedia.com...
>>> Hi Nathan,
>>>
>>> Let me know how you get on with the support incident.
>>>
>>> Regards,
>>> Mark
>>>
>>> ----------------------------------
>>> Mark Fletcher
>>> WebAssist.com
>>> ----------------------------------
>>>
>>>
>>> Nathon Jones wrote:
>>>> Yes I did Mark and someone replied to say:
>>>> "There is nothing in Dynamic Dropdowns that will help you with this, so
>>>> you will have to account for it manually. "
>>>>
>>>> There was also some advice about Concatination but I'm really not sure
>>>> that's what I need to do.
>>>>
>>>> I'll add to the support incident I've submitted, in the hope that
>>>> perhaps this initial advice was not correct. Thank you.
>>>>
>>>> Regards
>>>> nath.
>>>>
>>>> "Mark Fletcher *WebAssist*" <mfletcher@webassist.com> wrote in message
>>>> news:e75kn6$s6p$1@forums.macromedia.com...
>>>>> Hi Nathan,
>>>>>
>>>>> Did you try submitting a product support incident? Feel free to
>>>>> contact me off list if you would like to discuss this further.
>>>>>
>>>>> Regards,
>>>>> Mark
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Nathon Jones wrote:
>>>>>> Hi. I've got the Dynamic Drop-Down extension from WebAssist and I am
>>>>>> using ASP/VB.
>>>>>>
>>>>>> Here are my tables:
>>>>>>
>>>>>> Countries
>>>>>> countryID
>>>>>> countryname
>>>>>>
>>>>>> Regions
>>>>>> regionID
>>>>>> countryID
>>>>>> regionname
>>>>>> operatingarea
>>>>>>
>>>>>> I have a customer registration form that asks the customer to select
>>>>>> a country. When they select a country this changes the region drop
>>>>>> down to only display the regions in that country....all that is
>>>>>> working fine. Great!
>>>>>>
>>>>>> However....I need to also save the operatingarea, for the region they
>>>>>> choose, in a hidden field so that I can also INSERT this to the
>>>>>> database as part of the customers registration.
>>>>>>
>>>>>> I am totally stuck at this point and WebAssist are telling me that
>>>>>> their extension doesn't handle this, period.
>>>>>>
>>>>>> How do I get the operating area, associated with the regional choice
>>>>>> by the user, to be inserted into the hidden field? Is this even
>>>>>> possible within one page, or am I going to have to create a page in
>>>>>> between the initial form page and the success page? I really dislike
>>>>>> those "middle man" pages, or a 0 second redirect page, and want to
>>>>>> avoid that if at all possible.
>>>>>>
>>>>>> Hope someone can point me in the right direction.
>>>>>> Thanks in advance.
>>>>>> Nath.
>>