Click here to Skip to main content
14,975,219 members
Home / Discussions / Database
   

Database

 
AnswerRe: Synchronization Pin
Wendelius24-Sep-08 12:21
mveWendelius24-Sep-08 12:21 
Questionhow to sort on text data type column ? Pin
King Shez23-Sep-08 20:41
MemberKing Shez23-Sep-08 20:41 
AnswerRe: how to sort on text data type column ? Pin
Blue_Boy23-Sep-08 21:09
MemberBlue_Boy23-Sep-08 21:09 
GeneralRe: how to sort on text data type column ? Pin
King Shez24-Sep-08 0:02
MemberKing Shez24-Sep-08 0:02 
AnswerRe: how to sort on text data type column ? Pin
Wendelius24-Sep-08 11:04
mveWendelius24-Sep-08 11:04 
Questionproblem with select within select Pin
wajans23-Sep-08 20:12
Memberwajans23-Sep-08 20:12 
AnswerRe: problem with select within select Pin
Blue_Boy23-Sep-08 22:19
MemberBlue_Boy23-Sep-08 22:19 
AnswerRe: problem with select within select Pin
wajans23-Sep-08 22:24
Memberwajans23-Sep-08 22:24 
Hi

I have tried to analyse my requirement below.

mainmenu--TableName
iMenuId   vRefTable----ColoumnNames
58            news   ---------Records

TableField
iMenuId     bIsPrimary    iTableFieldId  vFieldsName
58                 1        11             iNewsId

news

iNewsId          vTitle                            vUR
1                  news1                  http://www.gmail.com

I am storing tablenames in MainMenu in vRefTable coloumn and coloumn names in vFieldsName of TableFields table.
I want to extract tablename from MainMenu whose iMenuId=58 and coloumn name from TableField table whose iMenuId=58 and bIsPrimary=1 and iTableFieldId=11 i.e iNewsId. After this I will be having both table name and coloumn name, using this I want to extract data based on the table name & coloumn name which I am having.

Thanks again
Ansari
AnswerRe: problem with select within select Pin
Ashfield24-Sep-08 0:00
MemberAshfield24-Sep-08 0:00 
Questionreport procedure (advice) Pin
nelsonpaixao23-Sep-08 14:02
Membernelsonpaixao23-Sep-08 14:02 
QuestionEncoded Database Pin
TheEagle23-Sep-08 12:56
MemberTheEagle23-Sep-08 12:56 
QuestionMigrate Access Db to SQL Server. Pin
VentsyV23-Sep-08 10:04
MemberVentsyV23-Sep-08 10:04 
GeneralRe: Migrate Access Db to SQL Server. Pin
Wendelius23-Sep-08 10:28
mveWendelius23-Sep-08 10:28 
GeneralRe: Migrate Access Db to SQL Server. Pin
VentsyV23-Sep-08 10:47
MemberVentsyV23-Sep-08 10:47 
GeneralRe: Migrate Access Db to SQL Server. Pin
Wendelius23-Sep-08 11:09
mveWendelius23-Sep-08 11:09 
GeneralRe: Migrate Access Db to SQL Server. Pin
VentsyV23-Sep-08 12:09
MemberVentsyV23-Sep-08 12:09 
QuestionADO recordset.open connection.execute concurrent problem Pin
followait23-Sep-08 3:57
Memberfollowait23-Sep-08 3:57 
AnswerRe: ADO recordset.open connection.execute concurrent problem Pin
Ashfield23-Sep-08 5:00
MemberAshfield23-Sep-08 5:00 
QuestionDefault date format Pin
mikobi23-Sep-08 3:23
Membermikobi23-Sep-08 3:23 
AnswerRe: Default date format Pin
NeverHeardOfMe23-Sep-08 3:59
MemberNeverHeardOfMe23-Sep-08 3:59 
QuestionHow to perform a search in a table with given more than one paramaters (SQL SERVER EXPRESS 2008)? Pin
JUNEYT23-Sep-08 1:54
MemberJUNEYT23-Sep-08 1:54 
AnswerRe: How to perform a search in a table with given more than one paramaters (SQL SERVER EXPRESS 2008)? Pin
Ashfield23-Sep-08 4:58
MemberAshfield23-Sep-08 4:58 
AnswerRe: How to perform a search in a table with given more than one paramaters (SQL SERVER EXPRESS 2008)? Pin
nelsonpaixao23-Sep-08 13:13
Membernelsonpaixao23-Sep-08 13:13 
AnswerRe: How to perform a search in a table with given more than one paramaters (SQL SERVER EXPRESS 2008)? Pin
Kevin Horgan23-Oct-08 9:53
MemberKevin Horgan23-Oct-08 9:53 
Questionarray of string in procedure Pin
Shaista Shafiq23-Sep-08 0:59
MemberShaista Shafiq23-Sep-08 0:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.