site map - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

site map

Author

Topic

sucithra
Starting Member

7 Posts

Posted - 2010-10-15 : 04:47:22

query for site map:

home
xxxx
yyyy
y1
y2
y3
-y31
-y32

how to wite query for the site map

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-15 : 04:50:14

What is this?

No, you're never too old to Yak'n'Roll if you're too young to die.

kunal.mehta
Yak Posting Veteran

83 Posts

Posted - 2010-10-15 : 08:39:02

what exactly u wnat to do

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2010-10-15 : 15:01:22

Select site from foo ???

Terry

-- You can't be late until you show up.

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2010-10-15 : 22:01:15

quote:
Originally posted by tosscrosby

Select site from foo ???

that doesn't work. I get "Incorrect syntax near '?'."

I tried this and it worked though:

select 'site map'

this also works, depending on your exact requirements:

print 'home
xxxx
yyyy
y1
y2
y3
-y31
-y32'

elsasoft.org

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-16 : 06:01:17

quote:
Originally posted by jezemine

quote:
Originally posted by tosscrosby

Select site from foo ???

that doesn't work. I get "Incorrect syntax near '?'."

I tried this and it worked though:

select 'site map'

this also works, depending on your exact requirements:

print 'home
xxxx
yyyy
y1
y2
y3
-y31
-y32'

elsasoft.org

I like your humor

No, you're never too old to Yak'n'Roll if you're too young to die.

sucithra
Starting Member

7 Posts

Posted - 2010-10-18 : 00:07:34

hi
this is my table:site_pages:

page_id page_value page_index page_lvl page_skin_id page_order page_mods page_build page_tid page_sid page_auth_ip page_auth_user page_auth_tid page_auth_sid page_auth_xs_id page_auth_com_id page_auth_grp_id page_auth_tem_id create_user create_date edit_user edit_date remarks
----------- ---------------------------------------------------------------------------------------------------- ----------- ----------- ------------ ----------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ----------- ----------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ----------- ----------------------- ----------- ----------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
* 4004 2010-06-05 12:39:28.217 NULL NULL NULL
7 shortcuts 1 0 0 7 NULL v1 0 1 * * * * 10:100 * * * 4004 2010-09-01 10:52:30.180 NULL NULL NULL
* 4006 2010-10-13 17:45:22.100 NULL NULL NULL
705 shortcut_order5 7 1 0 5 NULL v1 1 1 * sucithra * * 90:100 * *
70501 shortcut_Order_5_order1 705 2 0 1 NULL v1 1 1 * sucithra * * 90:100 * * * 4006 2010-10-13 19:14:38.050 NULL NULL NULL
70502 shortcut_level2 705 2 0 2 NULL v1 1 1 * sucithra * * 90:100 * * * 4006 2010-10-14 17:44:09.900 NULL NULL NULL

and another table site_pages_content:

page_content_id page_id page_name page_title page_desc page_content_lang_id page_content_tid page_content_sid page_content_build page_content page_content_elements create_user create_date edit_user edit_date remarks
90 2010518 Search Request Search Request Search Request 1 10 1 NULL Search Request NULL 4004 2010-08-27 11:52:32.197 NULL NULL NULL
93 7 shortcuts Shortcuts Shortcuts 1 1 1 NULL Shortcuts NULL 4004 2010-09-01 11:07:40.000 NULL NULL NULL
174 70501 shortcut_Order_5_order1 shortcut_Order_5_order1 shortcut_Order_5_order1 1 10 1 NULL shortcut_Order_5_order1 NULL 4006 2010-10-13 19:14:38.080 NULL NULL NULL
175 90501 Create Page Create Page Create Page 1 10 1 NULL Create Page NULL 4006 2010-10-13 19:19:57.307 NULL NULL NULL
176 2000504 Delete Record Delete Record Delete Record 1 10 1 NULL Delete Record NULL 4004 2010-10-14 09:20:06.017 NULL NULL NULL
185 70502 shortcut_level2 shortcut_level2 shortcut_level2 1 10 1 NULL shortcut_level2 NULL 4006 2010-10-14 17:44:09.913 NULL NULL NULL
197 13 NEW NEW NEW 1 10 1 NULL NEW NULL 4006 2010-10-15 12:24:25.893 NULL NULL NULL
203 705 shortcut_order5 shortcut_order5 shortcut_order5 1 10 1 NULL shortcut_order5 NULL 4006 2010-10-15 12:44:18.367 NULL NULL NULL

(145 row(s) affected)

i need query for this:
index refer to the page id

example: site_pages
id
7 shortcuts (level 0)

===========================
705 shortcut_order5 7
=========================
70501 shortcut_Order_5_order1 705

70502 shortcut_level2 705

name:site_pages_content

93 7 shortcuts
203 705 shortcut_order5
174 70501 shortcut_Order_5_order1
185 70502 shortcut_level2

i my site map will should look like this:

shortcuts

- shortcut_order5
- shortcut_Order_5_order1
- shortcut_level2

thanks in advance

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2010-10-18 : 09:35:06

Perhaps if you follow the link (HOW TO ASK) in my signature, you will get an answer...
The link will show you how to give us the information we need to help (and the proper format).

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources