Displaying Records

[Mike1500]

Hello All,

Finally was able to connect my access database to DW, now I'm trying to
display the record set in DW. After adding the table?s column to my web page, I
tried previewing it in Internet explore with no success. A "File Download"
dialogue box pops up asking me if I want to "Save this file to disk" or if I
want to "Open this file from its current location"...Can someone tell me what
I'm doing wrong I want to be able to run the web page without the that dialogue
box. Thanks in advance.

[baz0hara]

not sure if this is relevant to you exactly but this is how i do it .. create
DNS to connect DW to database (assume you have this) you will know if the
database is listed on the connections tab. from the server behaviour tab,
click on the 'plus' sign. Then choose the 1st option which is something like
'create record set'. A pop up will appear which you can fill in with all the
details, then just drag the bindings you want fron the bindings tab to the
stage. hope that helps

[Manuel Socarras]

are you working with a remote or local server?

Mike1500 wrote:

> Hello All,
>
> Finally was able to connect my access database to DW, now I'm trying to
> display the record set in DW. After adding the table?s column to my web page, I
> tried previewing it in Internet explore with no success. A "File Download"
> dialogue box pops up asking me if I want to "Save this file to disk" or if I
> want to "Open this file from its current location"...Can someone tell me what
> I'm doing wrong I want to be able to run the web page without the that dialogue
> box. Thanks in advance.
>
>

[CarlGrint]

It sounds as though you do not have the internet services installed, if it is
ASP.

If you are not running IIS or PWS for ASP then the browser will not know how
to deal with your ASP page, and give you the Save as option.

I assume you are running this locally..?

If you are trying this on your live site it is possible ASP is not available.


Originally posted by: Mike1500
Hello All,

Finally was able to connect my access database to DW, now I'm trying to
display the record set in DW. After adding the table?s column to my web page, I
tried previewing it in Internet explore with no success. A "File Download"
dialogue box pops up asking me if I want to "Save this file to disk" or if I
want to "Open this file from its current location"...Can someone tell me what
I'm doing wrong I want to be able to run the web page without the that dialogue
box. Thanks in advance.

[happycrack]

Hi

Can anyone please tell me how I can manually specify the order in which
records display? Basically I have a page which displays records from a SQL
server database using ASP. Against each record i have 2 images (one up arrow
and 1 down arrow). I need to create a function which detects the record before
the current one (or after the current 1 if the current record should move down
the list) and then swaps the 2 values for the sort order. The sort order is not
the record ID but another column in the database.

Also can anyone tell me when I am adding a new record into the database, how
can I detect the previous record so that I can pull out the last sort order
number and increment this by 1 automatically?

Many thanks for any help.

[Manuel Socarras]

you can recover the records in the order you want:

SELECT fields FROM your_table ORDER BY order_field

then you can move back/forward with MovePrevious/MoveNext methods

HTH,

manuel

happycrack wrote:

> Hi
>
> Can anyone please tell me how I can manually specify the order in which
> records display? Basically I have a page which displays records from a SQL
> server database using ASP. Against each record i have 2 images (one up arrow
> and 1 down arrow). I need to create a function which detects the record before
> the current one (or after the current 1 if the current record should move down
> the list) and then swaps the 2 values for the sort order. The sort order is not
> the record ID but another column in the database.
>
> Also can anyone tell me when I am adding a new record into the database, how
> can I detect the previous record so that I can pull out the last sort order
> number and increment this by 1 automatically?
>
> Many thanks for any help.
>