 |
 |
|
|
|
|
 |
|
|
General
The ever-powerful List X module forum. Post your questions, new configuration ideas and reviews.
| You are not authorized to post a reply.
|
|
| Author |
Messages |
|
blondie63
Posts:9
 |
| 08/21/2008 12:59 PM |
 Alert
|
I've bought today ListX 1.9.9
I've started with quick build with a simply query like this:
select country as Paese, Testo, Latitude, Longitude, icona as IconID
from ASH_TreviRivenditori
join JetkeyCountry
on paeseID = countrycode
i click over "Click Here to Test your Query." and see my records, the i click to "finish" to save
Now module does'nt show records and if i go to Module/View Options/Query i see my quey modified as is:
Select * FROM (
select country as Paese, Testo, Latitude, Longitude, icona as IconID
from ASH_TreviRivenditori
join JetkeyCountry
on paeseID = countrycode
) x ORDER BY [SORTTAG,RivID]
Is it right ?
Is there a button to test query in this point (Module/View Options/Query)?
I've seen that deleting extra code and returning to my original sql code, ListX show my records correctly.
Is this a bug ?
Mauro |
|
|
|
|
svedire
Posts:107
|
| 08/21/2008 2:59 PM |
Alert
|
Hi,
After testing your query in Quick builder, below there is an option for Layout. Out of the radio buttons select grid(list) and you will be able to see your records.
Thanks,
Sindura
R2integrated |
|
|
|
|
blondie63
Posts:9
|
| 08/22/2008 3:28 AM |
Alert
|
Maybe i've not written well on first post...
i've two questions:
1. Can you explain me why i write a query code and "quick build" save another one ?
2. under Design your Grid/List i can choose Edit page & Detail page but i don't understand if quick build generate this page |
|
|
|
|
blondie63
Posts:9
|
| 08/25/2008 6:16 AM |
Alert
|
Sindura !!
Can you answer me please?
best regards
Mauro |
|
|
|
|
robert_chumley
Posts:595
|
| 08/25/2008 8:31 AM |
Alert
|
Hey Mauro,
The quick builder modifies the query you wrote to accomodate the sort headers on the grid view. When you click one of the columns, a messages gets sent back to ListX indicating the column name and sort condition for that column. For example if you have a column called Paese, then you will have a column on your grid called Paese. Then the tag will be replaced and your query will finally look like:
Select * FROM (
select country as Paese, Testo, Latitude, Longitude, icona as IconID
from ASH_TreviRivenditori
join JetkeyCountry
on paeseID = countrycode
) x ORDER BY Paese Desc
(this would change to Asc or not exist at all depending on how many times you click the link)
This may be confusing if you cannot see your results at all. I suggest two things. First, when you are developing you can use the debugger. This is available from the General tab, or you can turn it on from the menu on the page. Any time you see pink or red sections on your dubug notices, it means there is a SQL error. This may help to see if there are any problems with your syntax.
Second, make sure you are actually getting results with that query. Does you database have the information you are looking for and is it pulling in the right way?
Let me know if you have any other questions.
Thanks, |
|
Robert Chumley
r2integrated (formally bi4ce) |
|
|
svedire
Posts:107
|
| 08/25/2008 9:39 AM |
Alert
|
Hi Mauro,
I am sorry if I haven't answered your post to the point.
When you go for "Quick Builder" option, it asks you for the table name, primary key, and also gives you an option to test your query to make sure that it returns records from the database. After you choose your Layout, it gives you further options for an Edit page or Detail page. You should have added edit and detail pages before doing the quick build. Once you choose Page (which is one of the radio options available), you will be able to see the pages drop down. If you select one of these pages, the edit link that appears will take you to this page. Similar is the case with detail. If you select none(the other radio option available) you will not be able to see edit and detail links.
After you hit finish you will get back to the respective ListX module. You should be able to see the records by then. You will also see the column names with the ability to sort. the query appears different because we are providing an opportunity to sort based on the column names. You will be able to see this, if you go to View Options -> Format using SORTHEADER.
At this point, you can use the methods suggested by Rob to see if there is some problem with the query in returning the results.
To use the debugger, go to View Options, General tab, and under Debugging select the respective checkbox. If there is some error in the query, it shows up in red color.
Please do let me know if you have any further questions.
Thanks,
Sindura
r2integrated
|
|
|
|
|
blondie63
Posts:9
|
| 09/01/2008 6:50 AM |
Alert
|
Looking debug code i've seen the problem!
Quick Build take my primary key as default sort order but i've not included it in my select, maybe it's better if quick build ask my the default field for order !
Looking your documentenation is not clear that i need to create modify & view page and ALSO add another listX module for each pages !
I've re-done quick build with this steps:
1. i've created a black page , add ListX and configure it with quick build as edit page
2. i've created a black page , add ListX and configure it with quick build as detail page
3. on main page i've added a listX, configure it with quick build as Grid (List) page and i've choosen my edit and detail page
4. now my main listX show my records but when i click on pencil or lens listX redirect to wrong page ! Looking on View Options/Actions i see same redirection for both edit & detail:
Action Type = Action:Redirect
Variable Type = Link
Value = 1
But on quick build i've choosen the right pages !
Is this a problem of quick build ?
Last question:
The table that i've to edit has a field ntext, on edit & view page i need to have dnn html editor for this field, but quick build have choosen a normal inline editor, how can i change it ?
Thanks for your help
Mauro |
|
|
|
|
svedire
Posts:107
|
| 09/04/2008 9:05 AM |
Alert
|
Hi Mauro,
If you have set them to correct pages and still Quick Builder redirects you to a different page, then that is a problem with the Quick Builder. I will take a look at that. But, if you want to redirect to the edit or detail page (depending on your requirement) that you have created, go to Actions and change the link under Action:Redirect (for edit and detail) to the respective pages.
For the other question:
On the edit page and the detail page, you will see ListX modules. When you mouse over the little downward arrow(make sure the page is in edit mode), you will be able to see 'View Options'. Go to Format section under that and make the changes.
Hope this helps.
Thanks,
Sindura
R2integrated |
|
|
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.6
|
|
| Latest Post
|
 |
|
At R2integrated (formerly Bi4ce), we take support seriously. That's why we support our customers and DNN community with daily monitoring from our experienced engineering team. We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered. We ask that you review the documentation that we provide for our products before posting a question.
The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback. Please be sure to perform keyword searches for previous related forum responses.
To be helpful when submitting a new item, please include the following:
- DNN Version
- Module Version
- Admin Log Viewer Information
- Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST). Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.
Thank you for using our Forums.
Click here to register for the Forums
|
|
|
|
| © 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation
|
 |
|
|
|
 |
|