ASP.NET Discussion Boards

Re: exception: Missing semicolon (;) at end of SQL statement

Parwej Ahamad20-Jun-11 8:38

Parwej Ahamad

20-Jun-11 8:38

as your error stating, just place semi colon after the insert statement.

cmd.CommandText = "INSERT INTO tblCategory(CategoryName, OrderNum) " +
                      "VALUES(@CategoryName, @OrderNum); " +
                      "SELECT @@IDENTITY AS ID";

Parwej Ahamad
ahamad.parwej@gmail.com

Re: exception: Missing semicolon (;) at end of SQL statement

benams20-Jun-11 8:41

benams

20-Jun-11 8:41

I've just tryed it, it didn't help

Re: exception: Missing semicolon (;) at end of SQL statement

AspDotNetDev20-Jun-11 8:54

AspDotNetDev

20-Jun-11 8:54

How about adding a semicolon after the second SQL statement:

cmd.CommandText =
    "INSERT INTO tblCategory(CategoryName, OrderNum) " +
    "VALUES(@CategoryName, @OrderNum); " +
    "SELECT @@IDENTITY AS ID;";

Help a brotha out and vote Managing Your JavaScript Library in ASP.NET as the best ASP.NET article of May 2011.

Re: exception: Missing semicolon (;) at end of SQL statement

Parwej Ahamad20-Jun-11 8:55

Parwej Ahamad

20-Jun-11 8:55

Error is same OR giving different one? Can you try once to execute two separate statement on by one because I have double that Access generating instantly Identity value.

Thanks,
Parwej

Parwej Ahamad
ahamad.parwej@gmail.com

Re: exception: Missing semicolon (;) at end of SQL statement

benams20-Jun-11 23:13

benams

20-Jun-11 23:13

I've tryed adding semicolon and the error message I get is: "Characters found after end of SQL statement."
I guess it will work well if I execute 2 seperated commands, but my goal is to execute all in one command, if it's possible.

Re: exception: Missing semicolon (;) at end of SQL statement

Parwej Ahamad21-Jun-11 0:26

Parwej Ahamad

21-Jun-11 0:26

Hi Benames,

I haven't try from side, but I had searched on Google and they clearly mentioned that we can not execute multiple statement in single query against Ms Access DB. So may be cause of the error. So if possible execute two separated statement to achieve your goal.

Thanks,
Parwej

Parwej Ahamad
ahamad.parwej@gmail.com

Re: exception: Missing semicolon (;) at end of SQL statement

benams21-Jun-11 0:39

benams

21-Jun-11 0:39

Ok, probably you are right.
It goes well when I run it in 2 different commands.

UpdateProgress on upddatepanel triggers

Ali Al Omairi(Abu AlHassan)19-Jun-11 1:37

Ali Al Omairi(Abu AlHassan)

19-Jun-11 1:37

guys;
i want to show an UpdateProgress when triggering an updatepanel to be updated. like this

HTML

<asp:button id="button1" runat="server" text="button1" />
<asp:upddatepanel id="upddatepanel1" runat="server">
<triggers>
<asp:asyncpostbacktrigger ControlID="button1" EventName="Click" />
</triggers>
</asp:upddatepanel>
<asp:UpdateProgress ID="ModalUpdateProgress1" DisplayAfter="0"
        runat="server" AssociatedUpdatePanelID="upddatepanel1">
 <ProgressTemplate>
     Loading ...
 </ProgressTemplate>
</asp:UpdateProgress>

what do you think?

Help people,so poeple can help you.

Re: UpdateProgress on upddatepanel triggers

Parwej Ahamad20-Jun-11 8:35

Parwej Ahamad

20-Jun-11 8:35

You don't want to use UpdateProgress control?

Parwej Ahamad
ahamad.parwej@gmail.com

Re: UpdateProgress on upddatepanel triggers

Ali Al Omairi(Abu AlHassan)21-Jun-11 22:47

Ali Al Omairi(Abu AlHassan)

21-Jun-11 22:47

Sir;
The existing UpdateProgress shows its content on asynchrnous postbaks just in the case of the postback control was a child of the AssociatedUpdatePanel if any.
what i am trhinking of is inheriting from UpdateProgress adn add a new property of type List<string> named AssociatedUpdatePanelTriggers that holds triggers ids of the AssociatedUpdatePanel and push them to the javascript version of the class on method Render() though ClientScript.RegisterStartupScript()

what do you think?

Help people,so poeple can help you.

how to start MVC

somasekhara77718-Jun-11 4:40

somasekhara777

18-Jun-11 4:40

actually i worked with asp.net and now i will go throw MVC. i need example for MVC plz help me
thank u

j somasekhar

Re: how to start MVC

Philippe Mori18-Jun-11 5:04

Philippe Mori

18-Jun-11 5:04

Here you will find lot of usefull tutorials and videos. Check "Learning Resources" section. At the top of that section, there are also links for additionnal content.

http://www.asp.net/mvc[^]

Philippe Mori

Re: how to start MVC

somasekhara77718-Jun-11 6:37

somasekhara777

18-Jun-11 6:37

thank you

j somasekhar

Re: how to start MVC

Prasanta_Prince19-Jun-11 6:24

Prasanta_Prince

19-Jun-11 6:24

@Philippe Mori Good link.

Problem in web application deployment

sakssp17-Jun-11 20:19

sakssp

17-Jun-11 20:19

When I deploy my web application and when two persons (administrator, Encoder) logged in at same time to my web application then the pages gets interchanges between the logged in users.

We have develop the software in ASP.net VS-2008 and SQL Server 2005.

Re: Problem in web application deployment

R. Giskard Reventlov17-Jun-11 20:50

R. Giskard Reventlov

17-Jun-11 20:50

Not nearly enough information to be able to help. e.g. does this happen on the dev box as well? Are there any exceptions reported? Is it your design? Also, not clear what you mean by 'pages get interchanges betwen th elogged in users'???

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum

me, me, me

Re: Problem in web application deployment

somasekhara77718-Jun-11 4:57

somasekhara777

18-Jun-11 4:57

you are developing a web application rite. there is no problem how many users will be logged in. suppose with same user name u will login with different browsers rite there will be nothing happens. first ask the question clearly i am not getting ur question

j somasekhar

Session variables

David Mujica20-Jun-11 2:52

David Mujica

20-Jun-11 2:52

I'm going to guess that you are having a problem with security rights or something like that.

Are you using session variables (or global variables) to store data between pages or postbacks ? I bet you are mixing things up and that is why you are seeing strange behavior.

Just a total guess. You didn't give enough detail of your problem.

Give more detail like:
1) User A does ...
2) User B then, ....
3) User A sees ....

More detail will lead to a faster and more accurate response.
Good luck.

Re: Problem in web application deployment

Morgs Morgan20-Jun-11 3:37

Morgs Morgan

20-Jun-11 3:37

Hi,
Here is my guess of what could be causing your applications behaviour.
You are using Cache["Id"] e.g. to store user data!
If that's the case, the cache object sits on the servers hard disk and your cache data will be used when ever your application is invoked by IIS. As you may have noticed, the Cache["id"] is not unique which is why your application displays different data to each user depending on who request server data first.

Cach["key"] objects are different from Session["key"], google this one out!
SOLUTION:
Make all your Cache["key"] variables unique hence the name "key" to something like:

//all these cache objects will be unique per id (or anything at mind)
Cache["id" + id] = id;
Cache["username" + id] = username;
Cache["password" + id] = password;

to retrieve each cache, you might want to pass the "id" in a querystring from page to page.

Shout if you have any trouble. Also consider carefully when to use Cache, Cookies, or Session objects to store user data.

Morgs

WYSIWYG Editor That Limits Size of Document

RHall7817-Jun-11 10:50

RHall78

17-Jun-11 10:50

I have a project that I need to allow the user to format text but with the constraint that the control limits the maximum height and width of the input text to a predetermined size. Eventually this HTML will be exported to RTF which will be input into another process, but I cannot pass more text than fits into this area size.

I have looked at various HTML editor controls for ASP.NET such as DevExpress' ASPxHtmlEditor or just plain javascript HTML editors such openWYSIWYG or TinyEditor but they do not look like they support limiting the input text to the available size. Each of these expand the size of the editing area and add scrollbars. I did play with prototypes that set the overflow style to hidden and it looks like it works, but the extra text is just hidden at the bottom. I thought about trying to get access to whether scroll bars are present after setting the wysiwyg textbox, but I can't figure out how to reliably tell whether they are present.

Does anyone know of how to accomplish this? Are there any controls that already have this functionality? The user base can be IE only.

Thanks for your help.

HTML Editor

berba17-Jun-11 2:45

berba

17-Jun-11 2:45

Hello,

Is there any HTML editor control for ASP? My client wants to include one in his ASP application

Cheers

Re: HTML Editor

jayantbramhankar17-Jun-11 3:06

jayantbramhankar

17-Jun-11 3:06

Try free Html editors
http://tinymce.moxiecode.com/[^]
CKEditor
OpenBEXI
AtomWrite

Re: HTML Editor

Ra-one17-Jun-11 3:15

Ra-one

17-Jun-11 3:15

you can use ajax editor control comes with the ajaxcontroltoolkit.

FckEditor can be the another choice.

Search google get the download link and download the same.

hope you get what you want Big Grin | :-D

Re: HTML Editor

^That's Aragon17-Jun-11 3:35

^That's Aragon

17-Jun-11 3:35

You can use FCKEditor. But use version below 3.X, as it doesn't contain examples for ASP.
You can download it free. In the settings you just need to choose the connector for ASP.

There are some help files are also included in the source. So you can get configuration steps from the source it self.

Regards

Re: HTML Editor

Ali Al Omairi(Abu AlHassan)17-Jun-11 10:42

Ali Al Omairi(Abu AlHassan)

17-Jun-11 10:42

you can use this How to Create an HTML Editor for ASP.NET AJAX[^]

Help people,so poeple can help you.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.