Forms Question or Query Question..

Forms Question or Query Question..

Post by RWQ » Mon, 03 Oct 2005 07:35:02


I am building a simple product configurator (select features, asnd the app
will add the detailed PN, costs, sell, desc)

My form uses controls for each product feature, and is bound to a table.
Thus, one order will create one record, with multiple products - poor db
design, but I can't see a way around this.

Thuis, its means I have to normalize the data, which is not easy.

Any ideas on how to create a form, which will generate mutiple
products/records?

Thx
Ed
 
 
 

1. Newbie question - simple query questions

2. question row filter (more of sql query question)

I have a question about dataset rowfilter.
I have a list of event table in a database. each event has start-date and
end-date column. I grab these from db and save to dataset. And then I have
to do rowfilter of dataset to filter based on user's input.

Users can select the following as dropdown for filtering.
- last 30 days
- last 7 days
- today
- all pasts

for example for past 30 days filtering I build the following rowfiltering.

string dFrom = today.AddDays(-30);
string dTo = today;
sFilter += " ([event-start-date] <= #" + dFrom.ToShortDateString() + "# AND
[event-end-date] >= #" + dTo.ToShortDateString() + "#) OR " ;
sFilter += " ([event-start-date] <= #" + dFrom.ToShortDateString() + "# AND
[event-end-date] >= #"+ dFrom.ToShortDateString() +"# AND [event-end-date]
<= #" + dTo.ToShortDateString() + "#) OR " ;
sFilter += " ([event-start-date] >= #" + dFrom.ToShortDateString() + "# AND
[event-start-date] <= #"+ dTo.ToShortDateString() + "# AND [event-end-date]
sFilter += " ([event-start-date] >= #" + dFrom.ToShortDateString() + "# AND
[event-end-date] <= #" + dTo.ToShortDateString() + "#) " ;

myDataView.RowFilter = sFilter;

But the above didn't return the correct resultset.

since each event has a start/end date and not easy to filter around to get
the correct result set. Please help!

3. [Question] Question about recursive queries in BIND9

4. Simple update query / form question DOH!

5. Query to Form Question

6. Simple Form/Query question

7. Access Query/ Form question

8. Query / Form Question

9. Form / subform / query question

10. Question about adding a field to a query/form

11. Query/Form Question

12. Forms and queries question

13. Simple update query / form question

14. question on using query to bind data to form

15. Dreamweaver Form Query Question