Forum: ASP  Jan 25th, 2007 |
| Replies: 3 Views: 1,648 Re: Select + update not working together
you can try this piece of code
set conn = server.CreateObject("ADODB.Connection")
set rs = server.CreateObject("ADODB.Recordset")
Conn.Open "DRIVER={Microsoft Access Driver... |
| Forum: ASP Jan 25th, 2007 |
| Replies: 0 Views: 2,513 |
| Forum: ASP Jan 25th, 2007 |
| Replies: 1 Views: 4,890 |
| Forum: ASP Jan 25th, 2007 |
| Replies: 3 Views: 1,648 |
| Forum: ASP Jan 25th, 2007 |
| Replies: 1 Views: 1,586 Re: No Error, No Insert: ASP to Access
hi there
it seems u r new to asp
here is ur mistake
instead of this
set sql_insert = conn.Execute (sql_insert)
use this
conn.Execute (sql_insert)
it will work |
| Forum: ASP Nov 24th, 2006 |
| Replies: 3 Views: 1,282 Re: printing throug asp
thanx for your reply
but i m not agree with you at the point
i m still on searching and inshahAllah will let u know once i get thte answer.
from my previous experience i have one advice for u which... |
| Forum: ASP Nov 16th, 2006 |
| Replies: 1 Views: 2,370 Re: passing the recordset data into an Array
information u provided is very less, but hope this will help
lets consider
"Con" is ur dbase cnnection
Dim Array1() --->keep it open for dynamic use
then
set Rs=con.execute("select * from... |
| Forum: ASP Nov 16th, 2006 |
| Replies: 3 Views: 2,743 Re: Seagate Crystal reports ODBC
I dont know ur expertiese but slution is very simple
u have to add these lines in ADORecordSet.asp file.
this file comes with seagate 8 samples, and i m using this file.
here is the code sample
for... |
| Forum: ASP Nov 6th, 2006 |
| Replies: 3 Views: 1,282  printing throug asp
Hi there
i have a page on which i have button to print the page
but the problem is before printing user needs to change the print option manually to landscape.
is there any wy tht user simply click... |
| Forum: ASP Nov 6th, 2006 |
| Replies: 1 Views: 1,114 Re: Sql In
he syntax should be this
"select * from tbl_name where mobile_no in ('firstvalue','secondvalue')"
what i think
the expression which you are creating for search criteria, i mean,"SSql"
should... |
| Forum: ASP Nov 6th, 2006 |
| Replies: 3 Views: 2,743 |
| Forum: ASP Nov 3rd, 2006 |
| Replies: 3 Views: 2,743 Seagate Crystal reports ODBC
Hi there
i need sample code to change ODBC of reports at runtime.
scenario:
i have few clients using differnt DSN but sae set of ASP code, my all reorts have been designed in crystal8 and asp.
now... |
| Forum: ASP Nov 3rd, 2006 |
| Replies: 4 Views: 1,181 Re: Hi friends... plz help me
yahoo/hotmial and other mail ervers has started new technique known as antispam, so these new domains wont be able to sent mails to these server unless you register your domian through process. |
| Forum: ASP Nov 3rd, 2006 |
| Replies: 4 Views: 1,181 Re: Hi friends... plz help me
hi there
i tried this long before but dont know abt current udates regarding winxp.
but last time when i tried this, i found that there are certain librries not present in XP, s these kind of fatures... |
| Forum: JavaScript / DHTML / AJAX Oct 21st, 2006 |
| Replies: 5 Views: 1,178 Re: having problem with some chars to display
Again thanx, i think now i have to do reate sme function to eleminate these string vhars, coz i think they are not too many, most of time they are attached with (") or ('), i was looking for some... |
| Forum: JavaScript / DHTML / AJAX Oct 20th, 2006 |
| Replies: 5 Views: 1,178 Re: having problem with some chars to display
thankyou
you are right may be, some time i cpy from yahoomails or other web sites. but how i can over come this situation as users will keep on doing this, they can copy text from any site and paste... |
| Forum: JavaScript / DHTML / AJAX Oct 20th, 2006 |
| Replies: 5 Views: 1,178 |
| Forum: ASP Sep 28th, 2006 |
| Replies: 0 Views: 1,839 Iframe and asp
Dear All
i m having very differnt problem i think
i hve one page in which i am using ifram and rich text box for html WYSIWYIG
but if i change the page extention to .asp instead of .html, every thing... |
| Forum: Networking Hardware Configuration Mar 24th, 2006 |
| Replies: 0 Views: 1,014 |
| Forum: MS SQL Feb 14th, 2006 |
| Replies: 1 Views: 2,027 Re: To retrive Recordno with records
Hello there
i myself find the answer
here it is , if u are also looking for it
http://www.sqlservercentral.com/columnists/mcoles/sequentialordering.asp
in SQLserver2000 there is no direct way, but... |
| Forum: MS SQL Feb 14th, 2006 |
| Replies: 1 Views: 6,889  Range of records in Top clause
Hello
have a good day
is there a way to retrive top records by range , i mean
like this
"select top 15 to 20 record from Table name any condition"
i dont mean top 15 or top 20, i mean records from... |
| Forum: MS SQL Feb 14th, 2006 |
| Replies: 1 Views: 2,027 To retrive Recordno with records
Hello
have a good day
is there any way to retrieve record number with each record in simple sql qry?
e.g
select "REC_no",name from "table_name"
the result should display like this
1... |
| Forum: Database Design Dec 7th, 2005 |
| Replies: 2 Views: 2,467 Re: Database question.. Can someone help...
abt ur first two points, i need to see the code u r using, are u suing access forms to retrieve and save or its some other programming language
abt third point, the default dateformat for access is... |
| Forum: MS SQL Nov 30th, 2005 |
| Replies: 2 Views: 8,879 Re: Default value of a column
you can write a trigger on a table for insert update
and dotn pass the value for field, so whever u will enter the row or alter it, the next field which is formula will be generated automatically,... |
| Forum: MS SQL Nov 30th, 2005 |
| Replies: 12 Views: 5,563 |
| Forum: MS SQL Nov 30th, 2005 |
| Replies: 2 Views: 32,269 Re: datetime format in ms sql
SQL take the datesettings from the windows, the default settings for SQL is american settings with MM/DD/YYYY
so in the control pannel in the regional settings u ahve to cahnge it to wht u want |
| Forum: Site Layout and Usability Nov 24th, 2005 |
| Replies: 0 Views: 3,444 Disallowed_Parent_Path
in some of my web pages, some links has to navigate through the directory access , not the pages reside in the same directory, every thing is workkign fine with my sys which is server2000, but when ... |
| Forum: MS SQL Nov 23rd, 2005 |
| Replies: 1 Views: 1,871 Re: new in sql world
hello
it is very easy to just begin with SQL
i m just assuming u will use ODBC connectivity
in converting Database from access to SQL u only need to consider these things
1-isnull function id... |
| Forum: MS SQL Nov 23rd, 2005 |
| Replies: 2 Views: 4,160 Re: I just need TIME not Date.
u can use combination of SubString and instr function and can extract time from the date-time stamp
if is wht u wnat get back to me, i will give u the example |
| Forum: MS SQL Nov 23rd, 2005 |
| Replies: 1 Views: 1,839 Re: transferring database/data to internet.
hello
abt ur first option i m totally confused, if u want to create a web sloution then u can do it, it doesnt seems any problem, wht exactly ur concern please explain
regarding ur second option... |
| Forum: Site Layout and Usability Nov 22nd, 2005 |
| Replies: 1 Views: 4,915 Http 500 -internal Server Error
Hello
I Was A Good Software Developer
Just Migrated To Web Development
I Want To Deploy A Site On Server2003 Standerd Edition
This Site Is Sql Based
When I Go To Aunhentication Pages
It Gives Me... |
| Forum: MS SQL Nov 22nd, 2005 |
| Replies: 1 Views: 14,126 Re: Compare two tables
HERE IS THE SAMPLE FOR CREATE AN UPDATE QUERY USING COMPARISON IN TWO TABLES
<sAMPLE qUERY<
UPDATE Table1
SET t.field1 = t.field3 + s.field2
FROM table1 t, table2 s
WHERE t.field4 = s.field1
AND... |
| Forum: ASP Nov 21st, 2005 |
| Replies: 1 Views: 2,384 how to print too wide page
Hello
i have a page which u can say abt 250col wide, and can grow in tht direction as well
left to write
when i go for print it cuts the remaining page
is there any normal way to print it
take care |
| Forum: ASP Nov 21st, 2005 |
| Replies: 4 Views: 3,403 Re: How to send mail
Hello
cdonts is server component and not avilable in XP, so thts why in xp there is cdo
so if u r deploying on server then no need to change
but if u r deploying on xp machine then u need to change it |
| Forum: MS SQL Nov 17th, 2005 |
| Replies: 0 Views: 1,842 user creation using msde
hello
i m using MSDE version with the web site i have developed for ASP
but i m unable to create guest user for internet access, which is defult builtin account by windows
plz help me this is very... |
| Forum: MS SQL Nov 17th, 2005 |
| Replies: 8 Views: 52,972 |
