Recordset problem

[chrisallen76]

Hi, here is my situation, in an access database i have a field which has 4
possible values (they are 'none', '1-2', '3-4', '5ormore') i want to be able
to select and disply a record count for the field to say how many of each out
come there are, so if there are 100 records in total i want to be able toshow
how many there are for none, 1-2, 3-4, 5ormore in turn. I can do this if i
make a recordset for each one but as this is an online questionnaire with about
15 questions this doesn't seem like its going to be the best way! can anyone
help because this is doing my head in! thanks chris

[-D-]

I've created a recordset and want to set the run-time value to a variable that
I need in the page. When I created the recordset, the run-time value isn't
initialized to the variable value. Here is the code DMX generated when I
created the recordset:

Dim rsStatus
Dim rsStatus_numRows
Dim rsStatus_role

Set rsStatus = Server.CreateObject("ADODB.Recordset")
rsStatus.ActiveConnection = MM_DBConn_STRING
rsStatus.Source = "SELECT STATUS FROM dbo.ABR_ROLE_STATUS_VW WHERE ROLE = '"
+ Replace(rsStatus__strRole, "'", "''") + "'"
rsStatus.CursorType = 0
rsStatus.CursorLocation = 2
rsStatus.LockType = 1
rsStatus.Open()

rsStatus_numRows = 0

The variable rsStatus_role isn't set. I tried manually setting the variable
as follows:

Dim rsStatus
Dim rsStatus_numRows
Dim rsStatus_role
rsStatus_role = role

Set rsStatus = Server.CreateObject("ADODB.Recordset")
rsStatus.ActiveConnection = MM_DBConn_STRING
rsStatus.Source = "SELECT STATUS FROM dbo.ABR_ROLE_STATUS_VW WHERE ROLE = '"
+ Replace(rsStatus__strRole, "'", "''") + "'"
rsStatus.CursorType = 0
rsStatus.CursorLocation = 2
rsStatus.LockType = 1
rsStatus.Open()

rsStatus_numRows = 0

the variable role is set before the above code is executed.

Any help is appreciated. Thanks.
-D-

[-D-]

Pleae disregard...I corrected the problem:

Dim rsStatus
Dim rsStatus_numRows
Dim rsStatus_role
rsStatus_role = role

Set rsStatus = Server.CreateObject("ADODB.Recordset")
rsStatus.ActiveConnection = MM_DBConn_STRING
rsStatus.Source = "SELECT STATUS FROM dbo.ABR_ROLE_STATUS_VW WHERE ROLE = '"
+ rsStatus_role + "'"
rsStatus.CursorType = 0
rsStatus.CursorLocation = 2
rsStatus.LockType = 1
rsStatus.Open()

rsStatus_numRows = 0

Thanks,
-D-

[René]

Dear all,

I have been trying to set up a database in dw8 but seem get error after
error.

somebody advised me that this could be a sounds like a rogue extension and
that this blog article might help
[url]http://www.tom-muck.com/blog/index.cfm?newsid=53[/url]

I looked at the information at the blog, uninstalled 3 serverbehaviour
extensions, but now get the message:

NAME = JavaScript error while loading Recordset.htm:
At line 1111 of file "C:\Program Files\Macromedia\Dreamweaver
8\Configuration\ServerBehaviors\PHP_MySQL\Recordse t.js":
theStr = theStr.replace(/(?>)*/gi,""); //remove close tags
SyntaxError: invalid quantifier ?

I tried changing this? But no joy!! I then repaired dreamweaver 8 and guess
what no joy again!!

Does anybody have any idea how to solve this. It's driving me nuts.

kind regards,
René

[Tom Muck]

> somebody advised me that this could be a sounds like a rogue extension and

> that this blog article might help
> [url]http://www.tom-muck.com/blog/index.cfm?newsid=53[/url]
>
> I looked at the information at the blog, uninstalled 3 serverbehaviour
> extensions, but now get the message:
>
> NAME = JavaScript error while loading Recordset.htm:
> At line 1111 of file "C:\Program Files\Macromedia\Dreamweaver
> 8\Configuration\ServerBehaviors\PHP_MySQL\Recordse t.js":
> theStr = theStr.replace(/(?>)*/gi,""); //remove close tags
> SyntaxError: invalid quantifier ?
>
> I tried changing this? But no joy!! I then repaired dreamweaver 8 and

guess

> what no joy again!!
>
> Does anybody have any idea how to solve this. It's driving me nuts.
>

Did you try the other techniques mentioned in the blog article? Delete or
rename your local configuration folder. The blog entry mentions where to
find it. If you delete that, Dreamweaver will be returned to it's installed
state.


--
Tom Muck
co-author Dreamweaver MX 2004: The Complete Reference
[url]http://www.tom-muck.com/[/url]

Extending Knowledge Daily
[url]http://www.communitymx.com/[/url]

[René]

Thanks for the advise tom.

I have deleted the config folder and it works all fine now.

Thanks for your help,
René


"Tom Muck" <tommuck@NOSPAM.basic-drumbeat.com> wrote in message
news:e0jdvb$mu6$1@forums.macromedia.com...

>> somebody advised me that this could be a sounds like a rogue extension
>> and
>> that this blog article might help
>> [url]http://www.tom-muck.com/blog/index.cfm?newsid=53[/url]
>>
>> I looked at the information at the blog, uninstalled 3 serverbehaviour
>> extensions, but now get the message:
>>
>> NAME = JavaScript error while loading Recordset.htm:
>> At line 1111 of file "C:\Program Files\Macromedia\Dreamweaver
>> 8\Configuration\ServerBehaviors\PHP_MySQL\Recordse t.js":
>> theStr = theStr.replace(/(?>)*/gi,""); //remove close tags
>> SyntaxError: invalid quantifier ?
>>
>> I tried changing this? But no joy!! I then repaired dreamweaver 8 and

> guess

>> what no joy again!!
>>
>> Does anybody have any idea how to solve this. It's driving me nuts.
>>

>
> Did you try the other techniques mentioned in the blog article? Delete or
> rename your local configuration folder. The blog entry mentions where to
> find it. If you delete that, Dreamweaver will be returned to it's
> installed
> state.
>
>
> --
> Tom Muck
> co-author Dreamweaver MX 2004: The Complete Reference
> [url]http://www.tom-muck.com/[/url]
>
> Extending Knowledge Daily
> [url]http://www.communitymx.com/[/url]
>
>

[Flog]

I have a weird problem that seems to have popped up on its own.
It seems that every one of my application recordsets are messing up.

When I edit or create a new recordset, the wizard shows my table selection
(from clause) as follows. (This is an example)

cfquery name="Recordset1" datasource="SVMC"
SELECT *
FROM C:\Data Sources\SVMC.users


It should be

cfquery name="Recordset1" datasource="SVMC">
SELECT *
FROM users

As a result, no application will work until I manually modify the from clause.

Any Ideas?

[BKBK]

<i>As a result, no application will work until I manually modify the from clause.</i>
I would manually modify it. Prevents another headache later.

[Flog]

Thanks for the reply , but I am looking for a solution, not just a work around, to the strange behaviour. Can anyone provide some more insight?

[paross1]

Sounds like a wizard problem, not a ColdFusion one. What are you using to generate your queries?

Phil

[Flog]

This seems to have started after applying the Dreamweaver MX 8.0.2 update on
this particular server however not on my other one. Therefore the common
denominator would be Coldfusion as one Dreamweaver works and this one doesn't.

Also it does not matter if I create a new recordset or veiw an existing one -
the from clause changes.

The error I get is MM_ERROR: -1

[paross1]

I would disagree and suggest that it is probably a Dreamweaver issue, but since I don't use Dreamweaver myself, I can't offer any recommendations as to where to look there.

Phil

[BKBK]

<i> I am looking for a solution, not just a work around</i>
The suggestion is not a workaround. The standard way to write a query in
Coldfusion is indeed

<i>cfquery name="Recordset1" datasource="SVMC">
SELECT *
FROM users</i>

It therefore doesn't surprise me that this version works.