I have written a SP which checks if a table(variable) exists,And removes the table if it exists,
SET NOCOUNT ON;
DECLARE @SQLQUERY varchar(1000)
SET @SQLQUERY='IF EXISTS (SELECT * FROM dbo.sysobjects where id = object_id(dbo.' + @tableName + ')) drop table [dbo].' + @tableName
exec(@SQLQUERY)
I found a lot of stuff on this topic but nothing that matches my problem.I'm coding a simple search function and came up with this code:
Dimsql
As
String =
"SELECT DMS_files.id, DMS_files.descriptionSV, DMS_files.description, DMS_MainCategories.categoryNameFI AS 'main', DMS_SubCategories.categoryNameFI AS 'sub' FROM [DMS_files] INNER JOIN DMS_MainCategories
ON DMS_files.cid=DMS_MainCategories.id INNER JOIN DMS_SubCategories ON DMS_files.scid=DMS_SubCategories.id WHERE (DMS_files.descriptionSV LIKE '%" & str &
"%' OR DMS_files.description LIKE '%" & str &
"%')"
If (User.Identity.IsAuthenticated =
False)
Then
sql = sql &" AND DMS_MainCategories.allowPublicSearch = 1"
End
If
With this I get the error "Multi-part identifier 'DMS_MainCategories.allowPublicSearch' could not be bound". But if I put the line straight to the first string, like below, it works.
Dim sql As
String =
"SELECT DMS_files.id, DMS_files.descriptionSV, DMS_files.description, DMS_MainCategories.categoryNameFI AS 'main', DMS_SubCategories.categoryNameFI AS 'sub' FROM [DMS_files] INNER JOIN DMS_MainCategories
ON DMS_files.cid=DMS_MainCategories.id INNER JOIN DMS_SubCategories ON DMS_files.scid=DMS_SubCategories.id WHERE (DMS_files.descriptionSV LIKE '%" & str &
"%' OR DMS_files.description LIKE '%" & str &
"%') AND DMS_MainCategories.allowPublicSearch = 1"
there is a statement like " select t.f1, (select ta.f2 from ta where t.fk1=ta.fk1) from t inner join ta on t.fk1=ta.fk1 "? In SQL 2005, this will get the message "The multi-part identifier "t.fk1" could not be bound.".beacuse the result will contains duplicate data from table ta in one row.
View 7 RepliesI have the following query:
select
good.fromwho
, good.applesdate,
good.starttime
, good.hungupfromwho
from
apples good
where
(
good.type
= 1
and good.result
= 2
and good.fromwho
not
inselect bad.towho
from apples bad
where
bad.type
= 2
and bad.result
= 1
and bad.applesdate
>= good.applesdate
and bad.starttime
> good.starttime
)
What I want to be able to do is add to my top selection statement columns from the "bad" table. If I try, it gives me
The multi-part identifier "bad.towho" could not be bound.
Is this possible?
I would like to create a multi-part form that can be used for entering and updating data.
From all of the tutorials it was unclear to me how to read the value of, for example, the text in a text box, so that I can update a database. One of the videos deals with using find control to find the values of controls that are inside item templates. That doesn't seem to be applicable here.
The second question I have is how to populate the value of a textbox or dropdown list from a database.
I want to do this programmatically.
Our current application is working fine but when you try to misbehave like we found out that When login with same user in multiple tab with different organization(there is a organization dropdown in the master page which sets the cookie whenever it is changed.) in tab one it is org 1 and tab 2 it is org2 , cookie has the later org 2 in it but when we go back in tab1(which had org1) and save the record org 2 will be saved with the record So can some one share some sort of a checklist with us which address these types of problem.
View 3 RepliesWe have several asp.net web applications we've built and we also want to embed them into various sharepoint pages. We need to have them look like standalone applications when viewed in their own pages, but also have them look like they fit within the sharepoint page when embedded. We are doing this currently with IFrames and it works ok, but I'm wondering if there is some sort of proxy web part where we can configure the web part to point to an existing web app and it will proxy the contents through from the web app into the sharepoint page removing the need for an IFrame. Possible?
View 2 RepliesI have four columns in database. Consider it as a,b,c and d. I'm trying to place a and b column values in TO part and c and d column values in CC part in outlook. a,b,c,d contains six digits numeric values. I just need to place a and b columns values in to and c and d values in cc part on click of a button.
View 1 RepliesWe have a simple ASP.NET app that uses the ASP.NET SqlMembershipProvider and all is great.
We want to create a second app on the same server, also use the SqlMembershipProvider, but a different "applicationName" so that the user accounts between the two apps are kept separate.
It looks like this would be possible by making the two different app domains (ie they each have their own web.config), but I'm hoping to just put them in different directories so I don't have 3 web.configs (one for each app, and the main one) that all have to be kept synchronized. So what I'm after is:
/web.config
/APP1 (uses membership provider in /web.config, with userlist A)
/APP2 (uses membership provider in /web.config, with userlist B)
It looks simple to define multiple membership providers that use a different 'applicationName' value.
But how do you tell the system.web.authentication node which membership provider to use?
When using SPWeb.GetCatalog(SPListTemplateType.WebPartCatalog), it returns an SPList which of course contains a SPListItemCollection of the web parts in the web part gallery. When looping through the items, is there any easy way to get properties of the web parts? Such as AllowClose, CatalogIconImageUrl, etc... I know I can probably accomplish this using the listItem.OpenBinaryStream etc and loading the xml of the .webpart file, but I wondered if there was an easier way to do this.
View 1 RepliesWhats the difference between a SharePoint web part and an ASP.NET web part. I found very less information describing the differences.
View 1 RepliesI'm putting some name/value entries into a GlobalResource file and am getting the error:
The resource name '01' is not a valid identifier
why '01' is an invalid name? Of course I will change the name to get around this for now, but am curious as to why the warning appears (in VS2010).
I m new in web part tools in asp.net, i create a simple page using web part tools, but now i want in my web part zone too open a web site like I Google..
when u use i google there is a functionality to open a web site in web part zone.
I have a page that save a record to a table. This is ok!
Now I want to do this:
After save the record, I want to pass the identifier of that record to another page (Page2.aspx) and get there that value.
My code is this:
[Code]....
[Code]....
Hacker's attack the session ID in asp.net application. How can we protect the session identifier from hackers.
View 1 RepliesI have an ASP.NET 3.5 Web Site.The application has to pass the IBM Rational AppScan before we can push to production.
I am getting the error:
Severity: High
Test Type: Application
Vulnerable URL: http://mytestserver/myapp/login.aspx
Issue: session identifiers is not updated
What can I do to fix this?
How do I convert a string to a uniqeid data type?
I'm identifying a logged in user. I use this code:
[Code]....
[Code]....
When I go to insert form data with LINQ to SQL, says it can't due to string not a unique id.
I realize that user names are unique, but is there another identifier associated with the username? If there is, how do I find out what it is for the user who is currently logged in?
View 2 RepliesI have a fresh install of 10g ODAC that I have loaded. My Oracle client interface connects to the db just fine but when I attempt to connect with my ASP.NET project, I get the following error: ORA-12154: TNS:could not resolve the connect identifier specified
View 3 RepliesI am just wondering how do I get the very last row of a join statement if I don't have any unique identifier... as in row_number field?Is there a way of creating a dummy column on my SQL statement to hold the record numbers of all records ..[1 to n] etc ???Id like to know how to do this and then I can get the MAX record number.Im using SQL server 2005 so the last() function doesn't work.
View 3 RepliesI'm creating a website with sql server db (built in membership database). I design it best possible. Im reluctant to use text fields as identifiers, but this is pretty much my first sql server db.
1. The user registers himself, at the same time registering his company/organisation. I dont think many of them will have the need to register themselves to other companys (N:N) but you never know (anyway not a main concern at the moment).
2. This user becomes a superuser (level1), with the ability to register other users to the same company (level2 users). Finally level1 can register level3 users to the same company.
So you see the identifier will be everywhere in the sql commands. There are quite a few N:N relations as well, which I guess slows it down even more. The selections typically retrieves a few hundred to a few thousand posts, but like I said, many will be in N:N relations.
what is this error and how to solve
a different object with the same identifier value was already associated with the session:
I'm going to write my own Authentication module and I need a unique identifier base on users requests header , I think [(user IP)+(user Agent)] can be reasonable but I know it's not completely safe do you know any other options or methods?
View 3 Repliesin the code in front i have:
Code:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:SQL2008R2_799650_xnacsConnectionString %>"
SelectCommand="SELECT [ArticleTitle], [articlehtml], [submittedby], [datesubmitted] FROM [Articles] where articleid ='@id'">
</asp:SqlDataSource>
and code behind is taking a url param (guid) and passing it to the select above
it looks like this:
Code:
protected void Page_Load(object sender, EventArgs e)
{
string id = Request["article"];
as simple as that, the problem is the page falls over saying it cannot convert string to Unique identifier, I'm new to asp.net but not c# so there are a few bits i'm trying to get my head round..
First of all here is my code chunk.
[Code]....
Right now I am creating this session with the session key "PhonePart" which is also the name of object I am passing in as a parameter in first method. In subsequent methods, I use the the same name to retreive and clear session value. My problem is, this approach works fine If I instantiate a single object of the class where these methods are defined and using that object call the methods, but when I create another instance of the same class and calls for instance method AddToSession and pass that instance, it overwrites the session value stored by the first instance of the class as the session key is the same that is "PhonePart".
Considering this scenario, is it possible that I somehow grab the name of the object as string in the calling method say "AddToSession" and create a session with that name? If Yes, then I can do the same in subsequent methods and retreive session value and also clear the session specific to that instance name without affecting the other session values stored by other instances.
