Multiple record update extension issue (felixone

[deadlyhifi]

I just purchased the Multiple Records at Once Extension by Felixone. I have put it to good use but have noticed an issue with it. PHP MySQL.

I am using Dreamweaver 8 with the Repeat Region behaviour, and the Recordset Navigation Bar, along with the extension to update multiple values at once from a recordset.

If there are more records than can be displayed on the first page of navigation. E.g. Showing records 1-10 of 15, when doing a multiple table update (in this case changing a single value from 0 to 1 and vice versa) a MYSQL error comes up. The operation is still completed but it doesn't go to the page specified after the update in the extension, but stays on the current page with the following error at the top:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

In the mean time, to overcome the issue, I am able to display all records on a single page, however once the records build up it won't be acceptable to have a potentialy very long list of records when I would like to display only 15 at a time.

Has anyone had any experience of this, and if so would you be willing to help me. I have emailed felixone but I need this sorting out ASAP.

Notice I have changed the show results to 5000, as going into the repeat region behaviour and saying 'show all' would not do anything. It always put it back to ten.

[Newsgroup_User]

Thank you Anurag,
I have already the db created ,

My question is how best to get the users local time availability into the
database, what is the best method to use, should I use list menus, etc, has
any one had to do this in a project before.

and then when some one comes to my site i want them to be able to compare
the time stored with the time of the site users country locally using an if
else statement. i am using asp vb and sql server

regards

kenny





"Anurag" <chetan_anurag@yahoo.de> wrote in message
news:e58mta$kbg$1@forums.macromedia.com...
> Well basically first you have to collect:
> a, the users phone number
> b, the "display times"
>
> and store those values in a database - don't even think about NOT using
> one
>
> Then you simply check when the page is called whether the current time
> is within the display time...
>
> Oh, btw you probably have to think about which time you are talking about:
>
> the mobile phone owner's local time, the viewer's local time, your
> server time...
>
> That should do the trick...
>
> Anurag
>
>
>
> twocans wrote:
>> hello,
>> I am looking to give my user a "show my phone number" option to show his
>> mobile phone number online and at selected times by that user, I need to
>> create a page that will allow my user to apply this as best and as easy
>> as
>> possible, my users are unaversial based. how best can I do this, is thre
>> a
>> snippet out there that anyone knows that may help. I am willing to pay if
>> any one knows of such suitable code.
>>
>> regards
>>
>> kenny
>>
>>