Showing posts with label pls. Show all posts
Showing posts with label pls. Show all posts

Friday, March 23, 2012

incorrect syntax

some one can help me about this error..i always get the error like this..but stilll dun know exactly what the error..pls help me..
here the message

Incorrect syntax near the keyword 'user'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'user'.

Source Error:

Line 51: Dim objdr As SqlDataReader
Line 52: conn.Open()
Line 53: objdr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
Line 54: List1.DataSource = objdr
Line 55: List1.DataValueField = "user_id"

Source File: c:\inetpub\wwwroot\register\update.aspx.vb Line: 53

Stack Trace:

[SqlException: Incorrect syntax near the keyword 'user'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
register.update.binddata() in c:\inetpub\wwwroot\register\update.aspx.vb:53
register.update.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\register\update.aspx.vb:42
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()

------------------------Hi,

What's your CommandText look like? Is it because the conflict of "reserved words"?

Colt

Wednesday, March 21, 2012

Incorrect printed pages in SQL Report-Imp. pls. reply asap

Hi
Can someone tell me why my printed pages from the print icon on SQL Report
2005
is different from the page # shown on the browser. Meaning, if I specify
that I want to print page # 10 of a 50 paged report, the printed output is a
different page and not the page #10 which is seen in the browser.
Any clues why this is happening?
--
Thanks,
SDRoyBecause on screen in your browser you are viewing it in pdf. If you want to
see exactly how your page will print you need to use print preview or export
to pdf.
"SDRoy" wrote:
> Hi
> Can someone tell me why my printed pages from the print icon on SQL Report
> 2005
> is different from the page # shown on the browser. Meaning, if I specify
> that I want to print page # 10 of a 50 paged report, the printed output is a
> different page and not the page #10 which is seen in the browser.
> Any clues why this is happening?
> --
> Thanks,
> SDRoy|||I'm sorry...I meant you are viewing it in html on screen in your
browser...forgive my typo please.
"KimB" wrote:
> Because on screen in your browser you are viewing it in pdf. If you want to
> see exactly how your page will print you need to use print preview or export
> to pdf.
> "SDRoy" wrote:
> > Hi
> >
> > Can someone tell me why my printed pages from the print icon on SQL Report
> > 2005
> > is different from the page # shown on the browser. Meaning, if I specify
> > that I want to print page # 10 of a 50 paged report, the printed output is a
> > different page and not the page #10 which is seen in the browser.
> >
> > Any clues why this is happening?
> >
> > --
> > Thanks,
> > SDRoy|||SDRoy,
Different renderers are being used, (html v. rtf) so the pagnation is
different.
thx
-jsh
"SDRoy" wrote:
> Hi
> Can someone tell me why my printed pages from the print icon on SQL Report
> 2005
> is different from the page # shown on the browser. Meaning, if I specify
> that I want to print page # 10 of a 50 paged report, the printed output is a
> different page and not the page #10 which is seen in the browser.
> Any clues why this is happening?
> --
> Thanks,
> SDRoy