User Profile

AliHabib · Apr 27 '09, 01:02 PM

I want to enter data with lenght greater than 4000 char so I chossed ntext

but when insert data like :
"
my name is Ali, Have the following data:
1. dddd
3.fff
4.rr
the end
"

just insert my name is Ali, Have the following data: only

how can insert data with same formate without lossing data

AliHabib · Jan 27 '09, 01:05 PM

I have a code when running it give this error messege (in sql server 2000)
Server: Msg 156, Level 15, State 1, Line 20
Incorrect syntax near the keyword 'EXEC'.

this is a part of the code

Code:

set nocount on
create table #DISTINCTC(
  [name] nvarchar(120)
)
insert into #DISTINCTC SELECT Column_Name FROM INFORMATION_SCHEMA.COLUMNS WHERE Table_Name = 'AGEN'
------------------------
select

...

AliHabib · Jan 13 '09, 02:21 PM

I have a database with column of type nvarchar , to let me insert Arabic words, but when insert using the asp code the insertion appear wron in DB (sql server 2005)

Code:

Open_User_ID = session("UserId") RPT_USER_ID = request("RepId") TCKT_SEVERITY_ID = request("severity") TCKT_DESC = replace(request("Desc"),"'","''") TCKT_SUB_PRJ_ID = REQUEST("SubPrjId")

...

AliHabib · Jan 4 '09, 12:39 PM

I inseted unicode language(arabic ) in varchar so it didn't bedisplayed will (it appears like ????????)

to solve that I modified the type of this column to nvarchar but I still can't read the old data any idea about that pleaase

AliHabib · Jan 4 '09, 09:48 AM

I inserted unicode language(arabic ) in varchar so it didn't be displayed will (it appears like ????????)

to solve that I modified the type of this column to nvarchar but I still can't read the old data any idea about that pleaase

AliHabib · Dec 31 '08, 02:39 PM

I write this stored procedure to modify the identity column depending on entered value it worked well just one time but now not work how can i fix this problem

Code:

create proc TickIDStart 
(
@IDnew int
)
as
	BEGIN
set nocount on
-- Allow the insert in the identity column
SET IDENTITY_INSERT TCKTs ON
--Insert any data and delete it to adjust the identity column	
insert into TCKTs

...

AliHabib · Dec 28 '08, 02:42 PM

Code:

<script language="javascript">

			function validateDate(fld) {
				var RegExPattern = ((^(10|12|0?[13578])([/])(3[01]|[12][0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(11|0?[469])([/])(30|[12][0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(0?2)([/])(2[0-8]|1[0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(0?2)([/])(29)([/])([2468][048]00)$)|(^(0?2)([/])(29)([/])([3579][26]00)$)|(^(0?2)([/])(29)([/])([1][89][0][48])$)|(^(0?2)([/])(29)([/])([2-9][0-9][0][48])$)|(^(0?2)([/])(29)([/])([1][89][2468][048])$)|(^(0?2)([/])(29)([/])([2-9][0-9][2468][048])$)|(^(0?2)([/])(29)([/])([1][89][13579][26])$)|(^(0?2)([/])(29)([/])([2-9][0-9][13579][26])$))

...

AliHabib · Dec 24 '08, 01:36 PM

when trying to set the sql statement by this code give error
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
/SearchSubject.a sp, line 129

Code:

	if request("TxtFrom") ="" and request("TxtTo")<>"" then
				if len(request("txtSearch2")) = 0 and len(request("Sens"))<> 0 then
					sqlPRJ = "declare

...

AliHabib · Dec 23 '08, 11:32 AM

Code:

Response.Write "<TD><A HREF=""ViewTicketDetails.asp?TicketID="&rsPRJ.fields("TCKT_ID") & """<" & rsPRJ.fields("TCKT_ID") &"</A></TD>"

this line I use to make the column return from the database in link form but it display nothing any one have idea

AliHabib · Dec 23 '08, 07:39 AM

I write a code to change variable by this if statement but it not work alwaysgive the else

Code:

if request("txtSearch2") = "" then

									
					'select case sens
					if request("Sense")= "on" then   
					sqlPRJ = "SELECT TCKT_ID,TCKT_OPN_DATE,TCKT_DESC FROM TCKTs WHERE TCKT_DESC like '%'+'"&request("txtSearch1")&"'+'%'COLLATE

...

AliHabib · Dec 21 '08, 08:58 AM

I want to retrieve data from sql server 2005 after clicking a button
so I do this code but it not work any help please

Code:

<html>
	<head>
		
	</head>
	<body>
		<%
			dim conn
			dim strconn ="Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MailSystem;Data Source=."
			Set cnt =Server.CreateObject("ADODB.Connection")

...

User Profile

Profile Sidebar

need your help please

How can sole that

Saving Arabic words into a database

how can i do that

How do i insert unicode text into varchar column?

what's the wrong with this stored procedure

validate input date

ADODB.Recordset (0x800A0E78) error

href problem

howto fixthis if statement

connect to sql server 2005 problem