Thanks for the response!
The initial INSERT may insert more than one record. So I would need all the user_id's at once to insert them into the other table.
...was somewhat descriptive.
I'm trying to INSERT records into a table, easy...
My insert statement is as follows:
INSERT INTO user_tbl
SELECT * FROM user_tbl WHERE user_id IN (SELECT user_id FROM list_user_index_tbl WHERE list_id = 11)
This is simple. I'm inserting the users that are in...
Hello,
On a web form, I dynamically create some panels at run-time which all have unique ids. The first time the page is loaded, it works great. If I refresh or navigate out and come back I get the following error.
Multiple controls with the same ID 'pnlQuestionHeader12968' were found...
Hey, thanks again for the quick response. Your help is helping me keep my sanity. I have a couple developers that were commited to Dreamweaver's Check In/Out functions and they are struggling with this concept.
Thanks! That is exactly what is happening. This process just seems a little cumbersome. Also, if I have any other files checked out, those files are checked in when the project file is checked in.
Greetings!
Recently, our company decided to migrate our website into ASP.NET. In addition to that, we are starting to use Visual SourceSafe 6.0. I have the database setup and all the users added and linked into the VSS database. A problem arises when someone makes a change to a project .aspx...
...'Setup the SELECT Command for email list
'-----------------------------
sSql = "SELECT user_tbl.user_id as uid, user_tbl.*, opt_out_tbl.email_address_vc as opt_out_address, psi_tbl.user_id as assignedtosurvey " & _
"FROM user_tbl...
I'm fairly new to the .Net world, but have plenty of experience in ADO, VB 6, ASP and SQL.
I'm creating a page that lists user in an email list.
In asp.net using ADO.NET, I've created the SQL statement, SQLDataAdapter, dataset and created a dataview of the list. Then bound the columns...
...of the email_address_vc field?
Because this doesn't work, email_address_vc needs to be in the select for the Group by to function:
SELECT u_tbl.*
FROM user_tbl as u_tbl
INNER JOIN list_user_index_tbl as lui_tbl
ON u_tbl.[user_id] = lui_tbl.[user_id]
WHERE (lui_tbl.list_id =...
If you are asking how to query a table with special characters, it's easy.
The only special character that will pose a problem is the single quote.
Example:
SELECT BarName, Address, City
From BarTable
WHERE BarName LIKE 'Joe''s%'
If there is a single quote in the search criteria, add...
...is 3 mins on a list of 5000 and 38 duplicates.
The user_tbl.email_address_vc is a varchar(300), which I think is causing the delay.
SELECT u_tbl.*
FROM user_tbl as u_tbl
INNER JOIN list_user_index_tbl as lui_tbl
ON u_tbl.[user_id] = lui_tbl.[user_id]
WHERE (lui_tbl.list_id =...
Hello.
Hopefully somebody has an answer to this.
My website imports a list of contacts from a tab delimited file and sets all the data into an array. I then loop through that array and insert each contact using a stored procedure.
I'm curious if there is a way to insert the whole array with...
I have a table that contains an ntext data type field. I need to do a search on that field to see if a record exists in that table. I'm running a stored procedure, but the data may have a single quote in it. I've tried two ways to try to run the query/stored procedure within vbscript/ASP.
1...
Oh wow! I uuuhhh. Sorry to bother the CF panel. But, I could have sworn this started happening after CF was installed. I thought I would try and update my drivers first. I also looked on MS site. Thanks.
This is probably an easy question.
I am populating a list from an array using the arraytolist function. Then I go ahead and display the list using the cfloop tag. My delimiter is ~N~. When the items are displayed, I lose the first character if the first character of the item is in the...
At the end of the day when I need to shutdown, my system hangs then an end task dialog box appears for devldr. I click the end task button and my system does one of two things:
-Hangs for about five+ minutes then shuts down.
-Never shutsdown.
Has anyone encountered this before. I am using...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.