Search:

Need some help....I am trying to insert a reather long peice of text...couple pages....Into Sql Server 2000. Once it gets so long it refuse to accept it. I have used varchar set to max and text. I...

I'm not getting an error it simply refuses to set the absolutepage to anything it just stays at one. the rs returns a page count of over 100 so the page and data should be there.

I am attempting to page through a recordset but it wount allow me to set the absolutepage. Any ideas?

I'll work on a way around that then. Thanks

I am trying to run this sql statement:


SELECT min(distinct(a.id)) FROM TBL_NOTEBOOK AS a WHERE Item_Type=1
AND a.id<>(SELECT d.id FROM tbl_notebook as d inner join tbl_checkout
as e on...

Try just this. Of course I am assuming rsholding is you recordset.

RSHolding("SubSectionID")

I think I made the assumption you were trying to do this in asp. Is that wrong?

IF i'm understanding you right, You could create a form for each row. with a submit. Then you would be able to submit each individual row independently from the other and then just update it

Did you set the odbc connection up?

Cool, thanks a bunch:D

Do you have code for that. Dont have a win2k machine to build the api and as usual msdn doesn't have any useful code that I have found.
Also what about the getdefaultprinter and setdefaultprinter...

Does anybody have the code for getting the default printer and setting it in windows 2000?

Can somebody figure out what is wrong with this sql statement for access97. It doesnt seem to acknowledge the default value i set for the column I am adding.


ALTER TABLE Tbl_Partners ADD...

Is there a trick to writing something in the temporary internet files folder in windows 95? Is there a way to do this through vb?

thanks

But then the macro will only be on my machine wouldnt it? I need to deploy this to multiple machines.

Anybody know how to set the margin in word through the word.application object in vb?

That worked, thanks

Tried that earlier and it still ignored it plus it doesnt give me the right results. For some reason it just wants to completely ignor it. Here is the whole thing.


SELECT
clname1,
clnum,...

I am running a stored procedure on sql server 7. It runs fine so far except its ignoring one of the where clauses, a.mstatus='OP'. any idea why from the code below?



WHERE
b.clstatus='C' ...

I could but the I would have to write a rplace for every html tag and then parse the text looking for hrefs,img,form... since the tags vary. I was hoping there was a better way to do it

could always try:


<% if 1=2 then %>

enter blah here

<% end if %>

You would have to determine in your code whether they have admin right. There is no server variables that contain that information. How you do that is upto you. you could set up a admin table and...

Anybody know how to go about removing all html from user entered text?

Anybody know if there is a way to access the data in a table on another database in a stored procedure. I would like to try and do this so I can reference a users name from another database by the...

Its the safe code from the other thread. I copied it to a class module and the compiler had a problem with the public const. I just cut thepublic of and it compiled fine. I call to readregeistry...

<>= might be part of it

Is there any problems running the api calls to the registry through a dll. I took the code from this thread:

http://forums.vb-world.net/showthread.php?s=&threadid=59606

i moved the code into a...

Figured I would haved to use apis, thanks for the code

Already tried it, there is no app name and that is not optional. All i have is the key

Im trying to get data out of the hkey_current_user. We set a key up under there called logon with a couple settings. now how do i get that info back out?

I think its just cool that they figured out how to do it now. May give linux a real chance now in the app area.

yep, wished i could convince them of that here

Not as far as i know. SQL server runs as a server so it respond to the request, access has to be connected to directly. Not sure if odbc would allow for that or not since i have never tried it

there are no better rps than chronotrigger:)

that should be it thanks:)

My turn:

Best rp ever: ChronoTrigger!!! cant believe it wasnt mentioned yet

best PSX Final Fantasy7
8 had better graphic but the story line and play wasnt as good

PC stategy...

interdevs not too bad either. Doesnt put all that crap in that frontpage does

i have a popup window on my page. when they click on a link i want the page to open in the main window, not the popup. Anybody remember how to do this?

true but he will get exposed and experience with it anyway. Asp will get him started quicker since its in more demand. Then he can learn xml in the workforce. Its simple enough to pick up and...