IT SOLUTIONS
Your full service technology partner! 
jdschram [Unspecified] -Collapse +Expand
-Collapse +Expand
jdschram
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (259)

Search jdschram:

Advanced
Personal Account . . .
jdschram
MN



Real Name:  jdschram [Unspecified]
Primary Role:  Coder
Title:  Programmer
Website:  http://schraj.cbj.net
Joined: Mar 2001 (24 years ago)
Visits: 263

Message Boards Activity

259 posts.
More...

Thread 6 of 6
Thread Starter or a Reply (but not last)  Group

jdschram
Re: Form
yup...using javascript a presume... this shoud be happening after the page has been submitted and the contents processed..., < !-- Begin, url=("PageToRedirectTo");, window.location=url; // End -->or < !-- Begin, url=("PageToRedirectTo");, document.write(' , // End -->
Posted to MB Topic: JavaScript « JavaScript Board
23 years ago
Nothing New Since Your Last Visit
2
Hits

JavaScript and AJAX

Thread 5 of 6
Thread Starter or a Reply (but not last)  Group

jdschram
Re: Access takes SQL numbers as strings - help!
It really does seem odd that it would contantenate instead of adding...without seeing code, make sure you are using + not &, you can also try this syntax to convert strings to integers., sum = cint("100") + cint("50")
Posted to MB Topic: MS Access Interactive « Access Board
22 years ago
Nothing New Since Your Last Visit
2
Hits

Microsoft Access

Thread 4 of 6
Thread Starter or a Reply (but not last)  Group

Vikas Athavale
Connect Sql Server on Web
Please inform me the sytax for connectring SQL server on web, , Thanksing u in advace, Vikas AThavale
22 years ago

jdschram
OLE, Set objConn= Server.CreateObject("ADODB.Connection"), objConn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;_, PersistSecurity Info=False;Initial Catalog=_, YourDB;_Data Source=YOUR_LOCAL_SERVER_NAMEDSN, Set objConn= Server.CreateObject("ADODB.Connection"), objConn.Open "DSN=mySystemDSN;" & _ , "Uid=myUsername;" & _ , "Pwd=myPassword"
22 years ago
Nothing New Since Your Last Visit
4065
Hits

ASP Classic Coding

Thread 3 of 6
Thread Starter or a Reply (but not last)  Group

jdschram
Re: Connect Sql Server on Web
OLE, Set objConn= Server.CreateObject("ADODB.Connection"), objConn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;_, PersistSecurity Info=False;Initial Catalog=_, YourDB;_Data Source=YOUR_LOCAL_SERVER_NAMEDSN, Set objConn= Server.CreateObject("ADODB.Connection"), objConn.Open "DSN=mySystemDSN;" & _ , "Uid=myUsername;" & _ , "Pwd=myPassword"
22 years ago
Nothing New Since Your Last Visit
2
Hits

ASP Classic Coding

Thread 2 of 6
Thread Starter or a Reply (but not last)  Group

jdschram
Re: Access Macros
yes there is...it's not too complicated either. Basically you would use the FileSystemObject (FSO) to create, open , write-to, and close a file. I've used this to write to a CSV file which can be opened by Excel. To create a CSV file it's pretty easy...a .xls file is a little tougher, and requires excel to be installed on the server. I would suggest the .csv file because it will run a little better., , I'm assuming you know how to make csv files...delimit by commas for the feilds and line breaks for the next record., , Here is some useful info , http://www.aspfaqs.com/aspfaqs/ShowCategory.asp?CatID=4 , , psuedo code, if file allready exists, delete it, then create it, else, create it, end if, open file with fso, connect to the db and execute SQL, while not rs.eof, write line to csv file, move next, wend, close rs, close db, close fileif you have more questions just post.., , HTH
Posted to MB Topic: Access VBA Programming « Access Board
22 years ago
Nothing New Since Your Last Visit
2
Hits

Microsoft Access

Thread 1 of 6
Thread Starter or a Reply (but not last)  Group

aka51
Access Macros
Does anyone know how to link an access Macro through a web browser using ASP.
Posted to MB Topic: Access VBA Programming « Access Board
22 years ago

jdschram
{Too Long!}
22 years ago
Nothing New Since Your Last Visit
3919
Hits

Microsoft Access
More...
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2025 Prestwood IT Solutions.   [Security & Privacy]