Can't get SubSonic insert to work

Posted by Darkwater23 on Stack Overflow See other posts from Stack Overflow or by Darkwater23
Published on 2010-04-29T17:20:21Z Indexed on 2010/04/30 7:17 UTC
Read the original article Hit count: 635

Filed under:

subsonic

|

query

|

insert

I'm trying to insert a record into a table without using the SubSonic object in a VB.Net Windows app. (It will take too long to explain why.)

Dim q As New SubSonic.Query("tablename") q.QueryType = SubSonic.QueryType.Insert q.AddUpdateSetting("Description", txtDescription.Text) q.Execute()

This just updates all the rows in the table. I read in one post that instead of AddUpdateSetting, I should use AddWhere, but that didn't make any sense to me. I don't need a where clause at all.

Searching for all:QueryType.Insert at subsonicproject.com didn't return anything (which I thought was weird).

Can anyone tell me how to fix this query? Thanks!

© Stack Overflow or respective owner

Related posts about subsonic

subsonic.migrations and Oracle XE

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, Probably I'm doing something wrong but here it goes: I'm trying to create a database using subsonic.migrations in an OracleXE version 10.2.0.1.0. I have ODP v 10.2.0.2.20 installed. This is my app.config: <?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> … >>> More
SUBSONIC 3.0.0.3 Subsonic.Query.SqlQuery

as seen on Stack Overflow - Search for 'Stack Overflow'
New to subsonic and having issues figuring it out. I am simply just trying to do a distinct search and any documentation I find is telling me to use the class/method SubSonic.SqlQuery Though I am finding out that since I am using the newest version, a lot of the documentation I am finding does not… >>> More
Error with SubSonic 2.0.3

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have to work on an application which used Subsonic 2.0.3. When I opened the project,I got a message The projectfile 'C:\Program Files\Subsonic\Subsonic 2.0.3\src\SubSonic\SubSonic.csproj' has been moved, renamed or is not on your computer. Does it mean I need to install Subsonic 2.0.3, I… >>> More
Benchmark Linq2SQL, Subsonic2, Subsonic3 - Any other ideas to make them faster ?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working with Subsonic 2 more than 3 years now... After Linq appears and then Subsonic 3, I start thinking about moving to the new Linq futures that are connected to sql. I must say that I start move and port my subsonic 2 with SubSonic 3, and very soon I discover that the speed was so slow… >>> More
Saving record in Subsonic 3 using Active Record

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having trouble saving a record in Subsonic 3 using Active record. I've generated my objects using the DALs and tts and everything seems fine because the following test passes. I think that my connection string is correct or the generation wouldn't have succeeded. [Test] public void… >>> More

Related posts about query

sort mysql query by filtered query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two mysql queries: $sql = "SELECT * FROM content WHERE threadName LIKE '%$filter%' ORDER BY lastUpdated desc"; and $sql = "SELECT * FROM content ORDER BY lastUpdated desc"; The end result is to have all rows returned from a particular table 'content' but have those that match the variable… >>> More
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query

as seen on Stack Overflow - Search for 'Stack Overflow'
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query i m using phpunit with doctrine framework .. i want to test my doctrine query with phpunit query with using phpunit framework methods.. any buddy with Doctrine Query and PhpUnit Query plz Contact... //Bhavin… >>> More
Converting sql query to EF query - nested query in from

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys Just wondering how the following sql query would look in linq for Entity Framework... SELECT KPI.* FROM KeyPerformanceIndicator KPI INNER JOIN ( SELECT SPP.SportProgramPlanId FROM SportProgramPlan PSPP INNER JOIN SportProgramPlan ASPP … >>> More
Sql Query - Limiting query results

as seen on Stack Overflow - Search for 'Stack Overflow'
I am quite certain we cannot use the LIMIT clause for what I want to do - so wanted to find if there are any other ways we can accomplish this. I have a table which captures which user visited which store. Every time a user visits a store, a row is inserted into this table. Some of the fields are shopping_id… >>> More
hql equivalent query to this sql query

as seen on Stack Overflow - Search for 'Stack Overflow'
Select top 1 from <tablename> what is hql query for the above ? >>> More