help?

textman

I need a little help to get me going.

I have built a web app in visual web developer and made and

inserted an sql db into the site with multiple .aspx pages.

It all compiles and seems great. Info from the db is displayed,however

when it comes to edit,  insert or delete it bombs out

"  incorrect syntax near'nvarchar'  or on delete........'int'

 some thing needs to be set to true...

All conection strings seem fine and test ok.

ps, whats the best way to to totally smash your dell laptop to pieces

and send it to pluto

Have included error

Jens K. Suessmeyer


Do you compose the commands on your own If yes, try to see what command(text) is actually executed against the database. if not, startup profiler to see the command executed.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

c blunt

I don,t write the commands yet myself....all key events.

I will check and reply

Many thanks

Jens K. Suessmeyer

Sure, come back if you have any questions.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

c blunt

Still got this glitch.

Could you have a look at the code for me.....the source code seems all to be ok with the target

Jens K. Suessmeyer

Seems that the statements posted do not contain any information about nvarchar, so I guess this is related to any trigger based on the tables. Have alook if there are any triggers which might get fired during the DML process.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

c blunt

Hi jens

thanks for your help recently.

I found out that i was trying to load data to my sql with the details view "tool" ................oops.

My test sql seems to be working like a train now. Also now discovering the full functionality

of sql and can see that im at the bottom of a large hill.

My next problem is publishing.

My hosting package has been upgraded to the version 2.0 asp.net runtime. and has sql enabled.

web dev.......copy function drops all the files into the server nicely and i can see them all.

The problem is it will not unwrap or show, and returns.........you do not have privaleges to view this htm.

All a bit strange to me but

I have not touched any of the security controls in the config manager or code.

regards Richard uk