Vasiliy
Posts: 378
|
| Posted: 01/20/2006, 9:49 AM |
|
I'm looking for a web-based visual Query Builder.
What I need (particular case):
I want to give my end-users a visual Query Builder so that they can generate a SQL request to read data from available parameters (table, columns).
In general I'm looking for an idea of a visual Query Builder.
Did somebody do similar tasks?
_________________
Vasiliy |
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 01/20/2006, 12:15 PM |
|
Vasiliy
Try this link: http://www.tufat.com/script.php?id_num=7
|
|
|
|
peterr
Posts: 5971
|
| Posted: 01/20/2006, 12:48 PM |
|
Please note that I edited the above message as a forum moderation feature kicked-in.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Vasiliy
Posts: 378
|
| Posted: 01/20/2006, 1:58 PM |
|
Edwin,
thanks for the link.
Sorry, I was not clear.
I need a concept/solution of a query generation.
Kind of a selection criteria builder.
For example CCS uses VQB.
It has 2 main sections:
WHAT we select (select a, b, c from xyz)
and
HOW we select (where a='B52' and b='F16')
Basically I need "HOW" section - some web-client (JavaScript) to generate HOW using a criteria builder.
Please, let me know if I'm still not clear, I just dived into the task and don't have clear examples. 
_________________
Vasiliy |
|
|
|
Benjamin Krajmalnik
|
| Posted: 01/20/2006, 4:04 PM |
|
Vasily,
I jsut founf this in phpclasses.org.
I don't know if it is what you are looking for, but may be a starting
pouint.
http://www.phpclasses.org/browse/package/2813.html
|
|
|
|
Vasiliy
Posts: 378
|
| Posted: 01/22/2006, 6:39 PM |
|
Thanks Benjamin,
unfortunately this is not what I need.
Btw, I finished save/restore form (search) values via JS. Let me know if you'll have a similar task, I'll share.
_________________
Vasiliy |
|
|
|
Walter Kempees
|
| Posted: 01/24/2006, 2:26 AM |
|
Am interested Vasiliy, sharing would be appreciated.
"Vasiliy" <Vasiliy@forum.codecharge> schreef in bericht
news:243d441d4d147f@news.codecharge.com...
> Thanks Benjamin,
> unfortunately this is not what I need.
>
> Btw, I finished save/restore form (search) values via JS. Let me know if
> you'll
> have a similar task, I'll share.
> _________________
> Vasiliy V Goncharenko
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Vasiliy
Posts: 378
|
| Posted: 01/24/2006, 12:14 PM |
|
Walter,
without going into a very specific code below is a link to a working example.
http://www.softcreator.com/files/CCS3/SCform_SaveLoad/testform.html
This file has:
1. JS code to save and restore values of any form object: entry, melti-select, radio ...
2. HTML form that demonstrates how to use this JS code with all possible form objects in it.
_______________________
More code later, when I organize the solution.
Basically on Save button I send form data+formname to a popup screen, that saves form data in a DB. DB Record structure:
_____________
CREATE TABLE [dbo].[UserSearches] (
[UserSearchID] [int] IDENTITY (1, 1) NOT NULL ,
[SearchName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[SearchDescription] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FormName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[SearchString] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
_____________
I'll prepare a better looking working example later.
_________________
Vasiliy |
|
|
|
|
