Viewing 15 posts - 31 through 45 (of 103 total)
i too was on the side of storing images into database. But the only reason i had to forgo that option was the response object in asp. I was unable...
Paras Shah
Evision Technologies
Mumbai, India
May 11, 2002 at 10:25 am
Sorry Steve, but I think you are missing out somewhere. RESPONSE object is ASP can set its contenttype only once. I have not tried it by using the ADO Streams...
Paras Shah
Evision Technologies
Mumbai, India
May 11, 2002 at 8:24 am
How do you set contenttype for one response object? It can be sent only once. If you are able to do it twice on the same page, pls let me...
Paras Shah
Evision Technologies
Mumbai, India
May 11, 2002 at 4:51 am
I had avoided storing into DB only for 1 reason. As I cannot show the image and the related text on the same web page. This is because, in ASP...
Paras Shah
Evision Technologies
Mumbai, India
May 10, 2002 at 1:26 pm
I had avoided storing into DB only for 1 reason. As I cannot show the image and the related text on the same web page. This is because, in ASP...
Paras Shah
Evision Technologies
Mumbai, India
May 10, 2002 at 1:26 pm
Does anyone have a reason why MS has not allowed Intersect, Minus queries even when they are allowed by most common databases. If such queries are allowed then many of...
Paras Shah
Evision Technologies
Mumbai, India
May 10, 2002 at 11:56 am
Storing images onto file system would be better efficient. You would find managing the files better if stored into database. But are the best person to judge what should be...
Paras Shah
Evision Technologies
Mumbai, India
May 10, 2002 at 11:54 am
1. User Defined Functions
2. XML Support
3. New Datatypes
4. Instead Of and After Triggers
5. Multiple Instances of RDBMS Engine on same machine
Many more, this is a few that i remember.
Paras Shah
Evision...
Paras Shah
Evision Technologies
Mumbai, India
May 6, 2002 at 10:27 am
This should work. Not too sure as I haven't tried it. But according to my knowledge, temp tables are available till they are droppped.
quote:
Paras Shah
Evision Technologies
Mumbai, India
April 28, 2002 at 2:40 am
Isn't there any alternative to OPENROWSET bcoz in OPENROWSET we have to pass username and password as 2 parameters. So when the username/password change on the server we manually need...
Paras Shah
Evision Technologies
Mumbai, India
April 28, 2002 at 2:27 am
Create a table called Messages and everytime insert records into messages table with the username/userlevel who should be allowed to see that message. Then in your frontend you can create...
Paras Shah
Evision Technologies
Mumbai, India
April 28, 2002 at 2:04 am
I want this for the local database. If I use if on the master database, I will have to do so same for the database on the web. The problem...
Paras Shah
Evision Technologies
Mumbai, India
April 27, 2002 at 8:24 am
well you can use else if you carry out your validations
if condition1
BEGIN
-- do something
END
else if condition2
BEGIN
-- do something 2
END
else if condition3
BEGIN
...
Paras Shah
Evision Technologies
Mumbai, India
April 27, 2002 at 8:14 am
Thankx for the help. It works fine. There are some utility stored procedures that I have created which I intend to use it in every database so to be on...
Paras Shah
Evision Technologies
Mumbai, India
April 27, 2002 at 7:50 am
Try this...
insert into table_bigone(userid, text_con)
select
table1.userid,
table1.text1 + table2.text2 + table3.text3 + table4.text4
from
table1, table2, table3, table4
where
table1.user_id = table2.user_id and
table1.user_id = table3.user_id and
table1.user_id = table4.user_id
Paras Shah
Evision...
Paras Shah
Evision Technologies
Mumbai, India
April 27, 2002 at 7:33 am
Viewing 15 posts - 31 through 45 (of 103 total)