Ask a Question related to ASP.NET General, Design and Development.
-
Paul #1
DataAdapter Insert data into a query
I have the query "SELECT * FROM [User Log] RIGHT JOIN VisiterInfo ON [User
Log].[Visiter ID]=VisiterInfo.[Visiter ID]" which I use to select data from
two tables to display on screen. I use an Access file with an OleDb
connection.
I need to be able to insert rows into this query so that both tables are
updated but I cant figure it out I have try tried the sql below plus many
other alterations of it but cant get it to work. Does anyone have any
Ideas?
"INSERT INTO SELECT * FROM [User Log] RIGHT JOIN VisiterInfo ON [User
Log].[Visiter ID]=VisiterInfo.[Visiter ID] ([VisiterInfo.Visiter ID], [User
Log.Visiter ID], [Visiter Name], [Visit Number], [Referer], [IP], [Date],
[Time], [Entry Page]) VALUES (@VisID, @UVisID, @VisName, @VisNum, @Ref, @IP,
@Date, @Time, @EntryPage)"
Paul Guest
-
INSERT Statement Query
Hi, I am about to embark on performing a data migration into a MySQL database. The goal is to be able to take the input data, and generate SQL... -
INSERT QUERY WEIGHT
Hi I would like to know if there is a limit in mysql to the weight of an insert query, I mean which size of data can I insert in my table at the... -
An easier way to insert data from Query Object intodatabase?
I'm currently using CFHTTP to get a CSV file and convert it into a QUERY OBJECT. I want to take this query object and insert it into a DATASOURCE I... -
SQL Insert Query using ADO
Hi, I am sending an SQL Insert query to my ADO connection object, my Insert query looks a litte like this... INSERT INTO tblRequests... -
INSERT error :: Updateable query?
I am picking up an error message on a straightforward INSERT - do I need an optimistic-type to get this working....here is is the error: ...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
