Wondering can we do like below.
SELECT @iSalary = Salary
Instead of doing old conventional way
DECLRE @iSalary INT
View Complete Post
I get a message - "Function without an 'As' clause" for HMAC_MD5 and "Variable declaration without an 'As' clause" for Key and Value. But the code works. But the messages still exists. Is there a way to fix this to avoid the messages?
Function HMAC_MD5(ByVal Key, ByVal Value)
Guys, i am looking for this using google search but without success yet...
How can I do this:
private string a, b, c, d ,e = "";
I want ALL the variables to start with "" but this is not what i get... so i am doing this until the answer does not come:
private string a,b,c,d,e;
a = b = c = d = e = "";
I have to write query in which i have to declare variable ,i dont want to use SP ,i tried to write in DATASET only.
The query which runs fine in Query window in SQL as below
declare @a int
Set @a=(select count(*) from roles where rolename='browser')
but when i run the same query in SSRS Dataset in throws error
"An error occured while the query design method was being saved. ORA-06550; line 1,column 9:PLS-00103: Encountered the symbol "@A" when expecting one of the following:
Being function package pragma procedure subtype type use <an identifier><a double -quoted delimited-identifier>form current cursor
Kindly Suggest how to declare variable in SSRS dataset
Hi all members.
I need to ask for the following code. I need to convert the variable into a string.
"Select Distinct convert (int ,A.CustomerCategory) as AccountReceivableCategoryID, convert (varchar(40), B.Text) as AccountReceivableCategoryNameE
from Inkunde A , inpara B
where A.CustomerCategory= B.SearchItem
and B.Language1 = 'EN'
and B.ParameterName = 'CATEGORY'
and A.CustomerCategory = (DT_STR,200,1252) "+ @[User::CategoryID] +"
Order By A.CustomerCategory"
Kindly any member let me know, How to correctly use the Type Cast fucntion in variables
Thanks and Best Regards,
Hi , I declared a user variable MINIODate as string in package level and assigned this variable in an execute sql task 2008 , where my source is ado.net and sql command is Select CSTR(MIN(IODate) ) as MINIODate from IOData ( This
is source table available in MSAccess DB) , The above senario working fine in 2005. During the run time in 2008 i am getting the following error
[Execute SQL Task] Error: An error occurred while assigning a value to variable "MINIODate": "The type of the value being assigned to variable "User::MINIODate" differs from the current variable type. Variables may not change type during execution. Variable
types are strict, except for variables of type Object.
I am using the following code:
var dbSelect = Database.Open("XXXXXX") ;
var selectQueryString = "SELECT * FROM XXXX ;
var data = dbSelect.Query(selectQueryString);
I am having problems with a user control. I want my solution to have a separate project for holding my user controls.
The main project can get a reference to this user control project and can import this user control dll into my main project.
Thanks in advance,
I'm looking to have a search page where a user will select an item from a listview, then then taken to another page that wil display data based on their original selection.
A user will type in a string and be presented with a list of usernames that are like that string, when they select a user name who's profile they would like to view I would like the page that they're taken to, to be that users profile.
How would I transfer the variable from the search page to the profile page, and when I work on the profile page, how can I access that variable?
I need to provide some alternate content for my non-Flash users.
I have a directory of video files that is scanned using the DirectoryInfo() function, and I want to use the results to embed all files ending in ".mov" in QuickTime players on a web form.
How would you approach this? Right now I am using the count on the array of videos to determine how many times to repeat the embed code. But this seems inelegant.
Is there a way to have a single QuickTime player.ascx control that gets duplicated according to the number of videos available for display?
How to take
value of bound field of grid in a variable or in a textbox.
I m using
this code in .aspx page for grid.
<RowStyle CssClass="odd" />
DataField="DOC_TYPE_PK" Visible="true" >
<asp:TemplateField HeaderText="DOC TYPE ID" Visible="true"> &nbs
I know I have a valid solution, but the js is telling me that the value in the hdnRecordSaved variable has no value!Even when I specify in my function the following, it still tells me it has no value:var myTextField = document.getElementById('hdnRecordSaved'); alert(myTextField);
When I put the full value of the variable in (ctl00_ctl00_cphTopCenter_cphCenter_hdnRecordSaved.value), I get the correct contents back ("1"), which I set in my code behind. However, I would prefer to just put the short name in since the masterpages may change, etc. Unfortunately, I know I can get around this with VS2010, but we are using VS2008.
What am I doing wrong with the js naming conventions that can't give me the contents? Here is my below js.
<asp:Panel ID="pnlMapFields" runat="server" ScrollBars="Both" Height="430px">
<telerik:RadTreeView ID="RadTreeView1" runat="server" DataTextField="Description"