SQL Server :: Use Variable In XQuery?
Sep 22, 2010
I want to use a local sql variable in XQuery.
Following is my table structure with columns and data type.
Orders
ID
Uniqueidentifier
UserID
Uniqueidentifier
OrderDetail
XML
OrderDate
DateTime
OrderDetail column contains XML in the following form.
<Books>
<Book BookID="033ba62a-3bbe-48cc-ad15-c3f28ff86306" Title="XYZ" Price="120" />
<Book BookID="805BC2BE-A91E-4E0E-A99E-C290D2EEEFF6" Title="XYZ" Price="120" />
</Books>
I want to select Orders (rows) which have BookID = "033ba62a-3bbe-48cc-ad15-c3f28ff86306". I am able to achive it through the following query.
Select * From Orders Where OrderDetail.exist('//Book[@BookID = "033ba62a-3bbe-48cc-ad15-c3f28ff86306"]') = 1
Now the issue is I want to use an sql local variable (@BookID) instead of the hardcoded BookID.
So How I can use a sql variable in a XQuery.
View 2 Replies
Similar Messages:
Nov 13, 2010
how to create a web site using c#(not used asp.net) ,xml,xsl,xquery ,xpath ,jquery
View 3 Replies
Jul 14, 2010
I'm evaluating two options of accessing a server side data on client side. Little bit confused about the efficiency or may be you can call it as finding best approach to do it.
I need to access a server side data may be an integer value in javascript on client side. I know about two options to do it.Create a public variable or property on server side and set it to javascript variable on client side as below:
var value = eval(<% =value %>);
Create a asp hidden variable and set value in this hidden variable from server side and access it through javascript using document.getElementById().
Which is the best approach and what are the pros and cons?
View 1 Replies
Nov 3, 2010
We recently migrated a web app from one Prod server (Prod 1) to another server (Prod 2). There is a session varialbe checked inside the page load event of the default master page. I have enabled session state both in web.config as well inside the pagedirective. The compilation went through without any issue. The web app is also running just fine on the server but the log file keeps logging a warning message. There is no run time error.
"System.Web.HttpException: Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the <configuration><system.web><httpModules> section in the application configuration."Any idea why this is happening on one server vs other?
View 3 Replies
Nov 25, 2010
If SubTotal is more than 500 I want @freightPrice to be 0. How can I do that?
[Code]....
View 4 Replies
Nov 25, 2010
I need to pass a table type parameter to a user-defined table valued function in SQL Server 2005.How would I do this?
My function name is udf_t_GetSales ( @financialYearMonthsData as table)
The table @financialYearMonthsData has 3 columns ( MonthId int, DisplayText nvarchar(500), CalendarYear int)
View 7 Replies
Jan 21, 2011
[Code]....
Above is dynamic sql and when it is executed by sp_executesql then I got output as as xml. If I want to store that XML in a variable. So then what I need to add in my tsql script.
View 1 Replies
Dec 6, 2010
I've defined a session variable in my Session_Start procedure
void Session_Start(object sender, EventArgs e)
{
<other stuff>
string sAdmin= bAdmin.ToString();
Session["SessionAdmin"] = sAdmin;
}
Then in my masterpage I want to use the Session Variable to conditionally show some links in a list.
How do I write the Boolean expression to correctly access the session variable SessionAdmin?
Here's what I have:
<div id="menu">
<ul>
<li><a href="/EmployeeTime.aspx">Employee Time</a></li>
<% if ( *** a Boolean expression involving Session variable "SessionAdmin" *** ) {%>
<li><a href="/Employee.aspx">Employees</a></li>
<li><a href="/ProductLine.aspx">Product Lines</a></li>
<li><a href="/Task.aspx">Tasks</a></li>
<li><a href="/Type.aspx">Work Types</a></li>
<li><a href="/Activity.aspx">Activities</a></li>
<%} %>>
</ul>
</div>
How do I correctly define my boolean expression? I've been looking, but haven't found the right syntax.
View 1 Replies
Oct 8, 2010
I want to use session variable for ConnectionStrings in SqlDataSource, so the same script can be used with different users with different databases. My SqlDatasource code is :
<asp:SqlDataSource
runat="server"
ID="sdsAvdeling"
SelectCommand="SELECT
* FROM [Avdeling] ORDER BY [Avdeling]"
ConnectionString="<%$
ConnectionStrings:UtstyrConnectionString %>">
</asp:SqlDataSource>
In Page_load, I assign the connectionstring for the SqlDataSource like:
sdsAvdeling.ConnectionString = Session["ConString"].ToString();
where
Session["ConString"]
is assign to "UtstyrConnectionString" when the the user logs in. When running the script, I get the following error: System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
View 4 Replies
Aug 5, 2010
how to Declare scalar variable
[Code]....
View 6 Replies
Mar 11, 2011
I would like to run a SQL query on the codebehind VB page that will also set a value from that query to a Session variable. Also, this needs to be done on the Page_Load.
Example:
[Code]....
View 3 Replies
Oct 26, 2010
sales.aspx.vb
Custom function which stores the current DATE into todayDate. I use this function to convert system date into SQL friendly date.
sales.aspx
I used Data Grid and SQL Data source.
SelectCommand="select * from sales where aab = 110026"
I want my select statement should take the date from todayDate.
i.e.: SelectCommand="select * from sales where aab = todayDate"
How to write this statement in correct syntax.
View 4 Replies
Oct 7, 2010
i am wishing to store the query result in any variable, have look at below code.
[Code]....
I have marked the code with bold, where I am getting error.
how do I store query result in any variable.
View 8 Replies
Jan 7, 2011
This should be really simple and I am new to asp development.
I am using ASP log in controls..when user logs in, I am storing the userid in a session variable. On this another page, I want to put the previously stored session variable value into a table using Insert statement.
in my sqldatasource..here is the code..
InsertCommand="INSERT INTO tblMain(PatientId, UserId, IncAge, IncDeNovo, IncAnginaIschemia, IncNative, IncLesions, IncStudyConform, IncStenosis) VALUES (@PatientId, @UserId, @IncAge, @IncDeNovo, @IncAnginaIschemia, @IncNative, @IncLesions, @IncStudyConform,
@IncStenosis)">
View 2 Replies
Sep 23, 2010
I want to recongize that a nvarchar variable in stored procedure is null or not null.
and this example :
DECLARE @Count int;
SET @Count = (SELECT Count(Fld) FROM Tbl)
if there is no row how much whould be the value of @Count?????
zero or null?
View 6 Replies
Feb 4, 2011
Inside a function I need to check to see if a variable value is null, how to do this? I implemented the code but its not returning the value I thought it would return.If it's null I want to set the value of the variable, else I want to query the value from a table
[Code]....
View 5 Replies
Feb 16, 2011
I have this procedure
[Code]....
I don't know what variable should be put in where clause for tblVisitor.visitorID because there's a variable that was already passed by an output identity parameter by a different stored procedure. What will I put in the where clause for visitor id?
View 3 Replies
Jan 26, 2010
This may be elementary user control stuff, but I can't get it to work.
How can I pass the Membership.GetUser.UserName variable (or any variable) through a user control parameter at load time?
[Code]....
The only thing that I was able to do was to create the User Control object in the code behind and then add it to the page. Although that works, it doesn't seem like the correct way to program.
View 1 Replies
Sep 26, 2010
I want to send an image to a stored procedure variable that is varbinary(max) field, It works correctly when an image selected by fileupload and my image property has image file, and it can send to stored procedure. but when fileupload is empty I want to send NULL to stored procedure variable that is varbinary(max). I use DbNull.Value in C# code. But error occurs. What should I do for send Null to stored procedure?
View 3 Replies
Mar 22, 2011
I am having trouble getting a SQL query to post its results to a Session variable. I am close, but no success thus far. Here is what I have:
[Code]....
However, I keep getting this error when I click to a new page that is using this "PracticeID" Session variable: No mapping exists from object type System.Data.SqlClient.SqlCommand to a known managed provider native type.
View 5 Replies
Jan 7, 2011
I have a table with about 300 OrgID's that I would like to pass into this sproc as the @Org_ID, so I don't have to do them one at a time. How would I do that?
insert into tblRelClients (client_ID, clientRel_ID)
select c1.client_ID, c2.client_ID from tblclients c1 inner join tblclients c2 on c2.OrgID = c1.OrgID
where c1.OrgID = @Org_ID
View 6 Replies
Aug 20, 2010
If I have the inventory class and want to make it to be xml and passed to web services and then web services will call stored procedure with xml as input parameters.
how to do in coding?
View 3 Replies
Mar 9, 2010
I have hosted my web forms files and reports files two different IIS instance in same server. When user login i keep username inside session variable. According to that session variable i checking roles each web forms page load event. i share session variable between two difereent IIS instance in same server?
View 1 Replies
Feb 27, 2011
I have a SQL stored procedure on a SQL server that uses a variable to create a new database. This works in SQL I have a connection string that works I have added a sqldatasource to a webform, and configured the datasource to connect to the remote SQL database and am able to select my stored procedure. I am able to bind the variable to a control in the sqldatasource wizard (often two of the same control appear- if that is significant)
When I test the sqldatasource in the configuration wizard and put in a manual entry, the procedure runs and works
It is on the web page I am having troubles. I want the user to enter a name in a text box, click a button/link, and run the procedure. Ive used buttons and links...but not in the right way I think, becuase when I click them the stored procedure doesnt run.
As mentioned above, I have selected the right control in the sqldatasource wizard. So what do I need to do now?
Is it button click event? If so whats the syntax?
Should I be embedding my textbox in a dataview?
View 4 Replies
Sep 9, 2010
My stored procedure expects a uniqueidentifier as a parameter. However, this unique identifier is stored in a table variable, which looks like this:
DECLARE @GiftGuid uniqueidentifie
View 14 Replies
