Explore topic-wise InterviewSolutions in .

HELLO EVERYONE,

PLEASE DOES ANYONE KNOW ANYTHING ABOUT INFORMIX AND INGRESS DATABASES? OR CAN YOU SUGGEST A SITE WHERE I CAN LEARN ABOUT THEM. I NEED TO KNOW THE COMMANDS USED AND HOW TO USE THEM. THANKS A LOT!Please do not type in all capital letters.
...and I'm sure that, whats on both our minds, is if this is HOMEWORK or not...... and why they can't spell "Ingres".
Quote

CAN YOU SUGGEST A SITE WHERE I CAN LEARN ABOUT THEM.

I need HELP creating a java program that inputs an AMOUNT of cents, converts the input amount to dollars, quarters, dimes, nickels and pennies.
Input the cents
dollars = cents/100
centsLeft = cents%100;
quarters = centsLeft/25
centsLeft = centsLeft%25
dimes = .....
Test your program with DIFFERENT inputs.I don't recall java having a modulus operator, I'm not sure about javascript, though.

You seem to have it- what exactly to you need help with?Its a straigth forward program ... .wat u want .... whole program
If you are facing any problem then let me .. please POST error msgQuote from: alyoob on July 22, 2008, 08:27:13 AM

I need help creating a java program that inputs an amount of cents, converts the input amount to dollars, quarters, dimes, nickels and pennies.
Input the cents
dollars = cents/100
centsLeft = cents%100;
quarters = centsLeft/25
centsLeft = centsLeft%25
dimes = .....
Test your program with different inputs.

looks like homework.

I need help creating a java program that inputs an amount of cents, converts the input amount to dollars, quarters, dimes, nickels and pennies.

now i have lost steam and the air is thinned i am reading others posts

installing the program c++ compiler is also my frustration
i have been bugging for help. i don't know how to ask so i ramble hoping the answer will come to me. the computer world and it's lingo is diffferent!

my question is why do these BEGINNER books direct you to do something that takes "advanced" computer programming skills"

secondly, why not design a program you can download, and boom your on your way to programming? (I should add with compiler that comes together with program)

are you suggesting compilers? or something like notepad just to enter the program?
if so how do you get it to work without a compiler?
in therwards how to see the end product?
i couldn't download the compiler(see posts)
so i USED notepad now what?
what is an API?Quote

installing the program c++ compiler is also my frustration

i couldn't download the compiler(see posts)

so i used notepad now what?

Compilation
-----------

GCC is a command-line compiler which you invoke from the DOS command
line. To compile and link a single-file C program, use a command like
this:

gcc myfile.c -o myfile.exe -lm

The -lm links in the lib/libm.a library (trig math) if needed. (Link
order is significant, so if you need libm.a, always put `-lm' at the
end of the command line.)

my question is why do these beginner books direct you to do something that takes "advanced" computer programming skills"

secondly, why not design a program you can download, and boom your on your way to programming? (I should add with compiler that comes together with program)

I would like to WRITE a SCRIPT that compares two columns CALL them A and B

If column A is greater than 0 AND column B is greater than 0 then add A to a running total.

If either column is blank or 0 do not add anything to the total. Also the columns are in ANOTHER sheet.

I WANT this total to be displayed in one cell.

Thankscan you give us a sample structure of you excel workbook?

THIS IS WHY I PROBABLY HAVE NOT BEEN ABLE TO USE THIS COMPILER YEA OR NAY?
NOT ONLY THE VARIABLES AND THE LONGFILE NAME SETTING BUT THE
REDIR.EXE,,,,,,AND THE SAGO GOES ON WRITE OR WRONG?Please do not type all in capital LETTERS. It is the same as shouting for attention, and cause the same sort of reaction.

Dias de verano - CAPSLOCK PATROL
Also- try to keep your posts within the same thread. SINCE this is a new thread, how is ONE to KNOW which compiler your talking about?

guys,,is there any way to edit a software?.. i wan to edit this software Ygamer trivia.. its a bot trivia for yahoo chatroom and i want to add features like commands of !help.. any one who can help? Edit Software? I don't know what Ygamer Trivia is but is this legal?there(http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=70276&lngWid=1) is the source code of it.

I don't use yahoo chatroom so I can't help to COMPLETE it.
But I GOT some infomation from the source code :

• it work with regexpression
• there is some dictionary(LIST of item)

Hi, the trouble starts when I run Visual BASIC 6. I have create a NEW user on my PC and I just want to run VB6 but APPEARS the WINDOWS Installer screen telling me that the Installation will start. I leave it until it finish but It doesn't never finish. Did you know what's wrong?

Regardsyou should insert the install cd of VB6 or
place the install file(s) to the path you last install from.

Or remove the VB and the reinstall it for all user.
there must be some options like:

• Only me
• All users

Hello;

I want to create a FILE that I can run and have a folder backed up to an FTP server folder. My laptop to my FTP server. Obviously I have a Username and PASS to contend with, but I control them on both sides. Any Ideas. I thought about a batch file xcopy, but I believe this to be out of the CAPABILITIES of this.

Any help would be great

Thankshey,

my first idea would also be a batch file.
You know the ftp command?

If you go to CMD you can enter FTP and press enter.

use it like:
open myftpserver.com

oder write HELP

that should work in an batch file..

Good luck..I don't know your FILES or paths,here I give you a sample of batch file to upload file to ftp server.
(there is a forlder named "temp" on the server,and at this moment the "C:\boot.ini" is exist, and the server ip is "10.1.11.59",this is my static IP in LAN)

Code: [Select]rem **** first write the command to file: ftp.txt****
echo user user1>ftp.txt
echo pass1>>ftp.txt
echo cd /temp >>ftp.txt
echo put C:/boot.ini ini.boot /q>>ftp.txt
echo quit >>ftp.txt
rem **** user the -s SWITCH to read the command in ftp.txt****
ftp -n -s:ftp.txt 10.1.11.59
rem **** after that delete ftp.txt****
del ftp.txt

after running this batch file
there will be a new file name "ini.boot" in the folder(or directory) "temp" of the server(10.1.11.59).

you can modify it to MATCH your demand.

Hi everyone, I have a little clue: I wish to develop an application, (modify and update), but it's developed in MS Visual Basic 5. I'd never programmed in VB5. Could I modify without some kind of issue in VB6 the sourcecode written in VB5?

Regards

Normally, when you OPEN VB5 project in VB6 that project is automatically converted into VB6.

But any feature used in your VB5 project may be(It depends upon your project) invalid or changed in VB6. Incase you must update or alter the source code to VB6.

After conversion it runs only on VB6 supported systems.VB5 and VB6 are so similiar VB6 could easily have simply been a service pack for 5- it adds a few functions with questionable value (like StrReverse), and several new features as far as objects/Classes are concerned, but unless you use these features, you'll have no problem going back and forth between VB5 and VB6 (although as you say you don't have VB5 anyway so that won't be an issue)

The sourcecode will almost definitely not have anything but trivial changes to be made, if any. I've converted projects from VB2 with very few problems, so I'd say that VB5 to VB6 are even fewer.Quote from: CBSk on June 26, 2008, 05:38:09 AM

Normally, when you open VB5 project in VB6 that project is automatically converted into VB6.

But any feature used in your VB5 project may be(It depends upon your project) invalid or changed in VB6. Incase you must update or alter the source code to VB6.

After conversion it runs only on VB6 supported systems.

Quote from: CBSk on June 26, 2008, 05:38:09 AM

Normally, when you open VB5 project in VB6 that project is automatically converted into VB6.

But any feature used in your VB5 project may be(It depends upon your project) invalid or changed in VB6. Incase you must update or alter the source code to VB6.

After conversion it runs only on VB6 supported systems.

Which SP do you mean SP5 or SP6?

Of course, I refer the VB6 Service Packs

I am tring to write strings and then DISPLAY them on the IC using the PARALLEL port. I have converted my name into a ASCI conde in hexadecimals the problem is I don't know what library is used for DISPLAYING into a seven segment displayer

Hello everyone, I'm seeking for a friendly subversion plug in for MS Visual BASIC 6.0 or Visual Studio 6.0. I've been found too many apps, but everyone WORKS only with the .Net environments.

Best regards!! Google turned up more than a few choices. Look these over, maybe you'll find something you can use.

Good luck. Well, I'd found the TortoiseSVN Repository, and it's a KINDLY app, and I found a plug-in adaptable to svn and winmerge.

You can find EVERYTHING about it in http://www.tigris.org/

Best Regards

Ok im new to this and ive read through some beginner books and i have a BASIC understanding of C++ and im trying to make a installer that will do simple tasks like downloading a file, extract it, and copy files to the specified directory. Is anyone willing to spare some time to help me with this? If so please send me a pm along with your msn. A source code of a installer already made would help too guys, thanks That actually SOUNDS like it would be more advanced. I suppose you could use system commands or the Windows API to make it alot easier, but there are lots of installers that use scripts to do what you want. I think Nullsoft makes a pretty good one if you just need an installer and not the learning experience.i noticed your having the same problem, i am getting the djgpp to work.
i am no PROFESSIONAL and do not even know what i am doing. well i know what i am doing and why. i am not sure it is going to work. i just have to keep working unitl it does. i asked the same question you did and got almost the same answer. i will tell what i decided to do.
i knew i was not going to get the program to run unless i explored it.
i think everyone and their family has worked building, modifying, and inventing
so i cracked into it and started opening folders and their directories.
i am finding out the beauty of why everyone is attracted to this program, you can open any folder (just a few you can't) with note pad.
i organized them (after all this is a lego*? program) according to function. i have learned a lot about the program it's self. i believe when i do get it up and going i will be able to understand the compiler in more depth.
in otherwards, do what you want with it. you can always get another. just wanted to let you know i am in the same boat. if you want to know how i have organized let me know. i have not got it up and running yet. most of the folders to this program you will begin to find out are information that iis informative to running the program. you will find out there is a hand ful that run the program. when you start opening them (if you downloaded them from the delories site), you will notice that all the folders have the same folder names but different (. text). keep a set of those folders. good luck
if you want to know more let me know
rubyRUBY02, this person asked for help on June 07, 2008.

It is now July 04, 2008.

Please don't dreg up old threads - not RELEVANT, as there is almost no chance they are still present. However, they can dreg them up if they want, because then they're present.

Thanks

Can anyone please HELP me by sharing the information of how to create a batch file to connect the BROADBAND CONNECTION automatically when I run the batch file. timing control is needed in the file.Broadband is always on. There is no need to DIAL in.

The connection can be enabled or disabled via a SCRIPT.

What are you trying to do?

Hi there,

I have *.csv file with many lines of users - Name,Surname,Mobile,etc.
What I want to do is create/use some script witch would parse this *.csv file, take these values from here and put this into another file - each user line into separate file.
In my case what I want is to put user information into an *.HTML templated file.
User info goes like this:

...
(1st line) Name Surename
(2nd line) Mobile
(3rd line) etc
...


I will appreciate if someone could point me where to start from or give some advice to solve this.

Best Regards,
SushyMore questions than answers for now. Are these HTML templated files being created from scratch, or do they exist and you want to insert records? Do all the records in the csv file have have same number of data fields? How many?

Any of the script languages, including the underpowered batch command language, can be used to parse the csv file.

I notice that name and surname are two chunks of data in the csv file, but are formatted to one line in the html file. Is this the only exception or are there others?

You have elipses (...) within the html tags. What do these represent?

Quote from: Sidewinder on August 07, 2008, 05:09:00 AM

More questions than answers for now. Are these HTML templated files being created from scratch, or do they exist and you want to insert records? Do all the records in the csv file have have same number of data fields? How many?

HTML file(s) exist and I want to insert additional records from CSV file.
CVS file looks like this: (Name,Surname,position,phone,mobile,fax)
Code: [Select]Johny,Beier,marketing specialist,12345678,12345678,12345678
Larry,Cash,administrator,,12345678,12345678
...
...
HTML file looks like this:
Code: [Select]<html>
...
Best Regards,
!Johny Beier
!marketing specialist
!12345678
!12345678
!12345678
...
</html>
Values marked with "!" I need to obtain from CSV file.

Any of the script languages, including the underpowered batch command language, can be used to parse the csv file.

I notice that name and surname are two chunks of data in the csv file, but are formatted to one line in the html file. Yes.
Is this the only exception or are there others?
As you can see above there are also empty ",," entries in CSV, cos not all have fax number or phone number, etc. In fact this CSV file is generated from XLS file.

You have elipses (...) within the html tags. What do these represent?
Ohh, sorry for vagueness, it was wrote as comment thought.

Did you test it

C:\temp\run.vbs(13, 3) Microsoft VBScript runtime error: Input past end of file

<html>
...
Best Regards,
...
</html>

In fact I`ve just realized that I need some changes to VB script, because my real html template file should look like this:

In the future, take a deep breath, think about what you need and then post your request

Hi, I've been found in a project the extensions .vbp and .mak, to define the VB6 PROJECTS files, but I don't know which is the difference between it and which kind of TROUBLE COULD I get replacing all to .vbp.

Cheers.mak is the old project extension for Visual Basic 1,2 and 3. VBP is from version 4 onwards. when you open a .MAK in a newer version of VB and save it, it still SAVES as a MAK.

You should have no problems renaming then all the .VBP.Quote from: BC_Programmer on July 04, 2008, 10:09:02 PM

.mak is the old project extension for Visual Basic 1,2 and 3. VBP is from version 4 onwards. when you open a .MAK in a newer version of VB and save it, it still saves as a MAK.

You should have no problems renaming then all the .VBP.

Hello everybody, I have a little clue about the attributes used in the instruction Dim. I would like to know what kind of function have the attribs As Form.

Regards!!!!The answer is "a form".

Quote from: Dias de verano on July 04, 2008, 10:13:48 AM

The answer is "a form".

are you asking what purpose it would have to Dimension a variable of type Form?

Quote from: BC_Programmer on July 04, 2008, 10:10:12 PM

are you asking what purpose it would have to Dimension a variable of type Form?

Yes I do.

I NEED to WRITE a C program to telnet into a device, and read INFORMATION from the device.
Can anyone tell me if there are any good tools which I can use?

Thanks a lot why write another program ? if your telnet client supports scripting, then you can write a script to do that. If you know Perl, you can use the Net::Telnet module. SEARCH google for Net::Telnet and see some EXAMPLES

can ne one provide me some basics for php and asp .net like der purpose and application where these languages are used and advice on books to follow for a fresher.Php for dummies. Asp.net for beginners.

Google "learn php" and "learn asp.net" for starters.

And both asp.net and php are used for websites. I use php for my own website.

As a footnote, they STAND for:

asp: Active Server Pages
php: PHP: HYPERTEXT Protocol. (yes, php is an anacronym of itself.)W3Schools is the best place I have found for web design tutorials.Quote from: kpac on June 24, 2008, 01:25:16 PM

W3Schools is the best place I have found for web design tutorials.

I have a question for anyone who can answer it. I need to write a batch file for to automate some things for someone who is computer illiterate. The problem is that it needs to ask her up to 8 multi word descriptions, that will get passed to a seperate program. There may not always be 8 descriptions, but in every case thay will not be one word. I can write very simple batch files with a single variable, but this is way over my head. I'll show an example of what I'm trying to accomplish below. Any help would be greatly appreciated.

The directory structure involved.

c:\archives
c:\archives\1
c:\archives\2
c:\archives\3
c:\archives\4
c:\archives\5
c:\archives\6
c:\archives\7
c:\archives\8
c:\archives\backups

The user INPUTS *should* be something like this...

What's on the first disk?
What's on the second disk?
etc...

Sample answers might be like the following:

Nico's Pictures
Family Geneology Info
etc...

Basically, we have a bunch of DVD backups from my Mother's old unstable computer, but we want to a.) RECOVER the important data, & b.) create a new backup that is organized the way my Mother will understand it. The contents of each directory are compressed with RAR to save space, so I need to check for errorlevels from each step. Right now, I can get most of it, but I keep getting stuck with the user inputs. So how do you ask the user for a variable that could be more than one word up to eight seperate times? She may not always need eight, but sometimes she will. It all depends on how much is on the original DVD that she wants to save.

Sorry for such a complicated one, but my idea of a tough batch file involves one single variable and a lot of excess code. I just don't understand loops other than simple IF THEN statements. Thank you very much for your help!A string variable can be as LONG as you like, and have as many "words" as you want. Did you think that a variable can only be one word?


Actually...YAH, I sure did. So how should I write the 8 user inputs? I want to avoid having my mother running the batch followed by all 8 variables in the same line. Knowing her, she'll have 8 very long titles. THANKS again...

I WOULD like to use Amazon's One TIME Use:
HTTP://developer.amazonwebservices.com/connect/entry.jspa?externalID=1184&ref=featured#Preparation
I have no idea how to program it. I was thinking about using one of those SITES where programmers bid on programming work.
How much would programming work like this cost?


Thanks,

Roscoe

hey guys, I have a school project. its about the compiler. but I dont have any idea on doing this. All I know is that we can use any programming language in my previous subjects and we will use it as a compiler (im not sure ).

can you guys explain what compiler is all about?

any advice would be appreciated...a lot of thanks Don't you have any text books?

A compiler CONVERTS source code and turns it into machine code the CPU can execute.

i don't have any books about compiler. it converts into any machine language? mmhh i think that is very complicated...anyways, what textbook can i use with this? i try to buy it.You should ask your teacher.
You could also try actually researching the subject. When I was in school I was TOLD this was a pretty important.
Here is a little to get you started.
http://en.wikipedia.org/wiki/CompilerQuote

You could also try actually researching the subject. When I was in school I was told this was a pretty important.
Here is a little to get you started.

hi guys. i want to install visual basic. but i dont know if what version of VB is ideal to use?

how can i run programming using Turbo C

You've written something in Turbo C correct?

yup, i try to run my program into the prototype. when i run the program in TC also with my prototype with the same output.

hey dude, im very confused what really compiler is? based on your last reply.

if you don't mind,
can you explain to me what a compiler is? can you give an example of compiler?

this is optional, if you want or not, it is ok for me.

anyways, thanks for your patience you give to me. i really appreciated it. thanks

A compiler is a computer program (or set of programs) that translates text written in a computer language (the source language) into another computer language (the target language).

Hey all,

I've got a big long list of user name in a excel sheet. I'm trying to write a script to determine weather the name exists in AD.

This is what I have so far (Pouched from Hey scripting guy!!)

Code: [Select]Const ADS_SCOPE_SUBTREE = 2

Set objConnection = CREATEOBJECT("ADODB.Connection")
Set objCommand = CreateObject("ADODB.Command")
objConnection.Provider = "ADsDSOObject"
objConnection.Open "Active Directory Provider"
Set objCommand.ActiveConnection = objConnection

objCommand.Properties("Page Size") = 1000
objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE

Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("C:\scripts\ADusers.xls")
objExcel.Visible = True

i = 1

Do Until objExcel.Cells(i, 1).Value = ""
strName = objExcel.Cells(i,1)
objCommand.CommandText = _
"SELECT * FROM 'LDAP://dc=mydomain,dc=com' WHERE objectCategory='user' " & _
"AND sAMAccountname='" & strName & "'"
Set objRecordSet = objCommand.Execute

If objRecordset.RecordCount = 1 Then
objExcel.Cells(i,2) = "Found"
Else
objExcel.Cells(i,2) = "Not found"
End If

i = i + 1
objRecordset.Close
Loop

objConnection.Close

The problem I have is that the list was generated from a list of extension numbers and there owners and are in First name Last name format. Our NT logon is First name First letter of last name. (Example - Adam Smith = adams)

The PART "sAMAccountname" part is using the names provided in the excel sheet and comparing against AD's logon usernames. This means that they all fail and aren't found.

I've found the object "cn" that compares against the display name instead (or at least I think it does) I've tried running the script with "cn" instead of "sAMAccountName" but it only finds about a 1/4 when I know that it should be closer to 3/4.

Any ideas why???

Have I used the correct method or is there a better way of doing this than what I've done??

Thanking you in advance
You may be trying to compare apples with oranges. Try listing the active directory users and comparing their format with the Excel name format (last name first?, first name first?, comma included?, etc)

You may have to manipulate the names in one of the data sources before you even attempt a compare.

Don't know MUCH about AD, but if a single user can have multiple entries, I WOULD check the recordset count for zero and not zero.

Good luck. Hey,

Thanks for the reply.

I managed to fudge a fix. I basically took the first name and the first letter of the surname and tested it against AD. If any name failed I then took the first name and 2 letters form the surname.

Since that is our standard it gave PRETTY good results. This is something i have to ever again, so it was close enough.

Cheers for the advice.

Hello,

I WANT to make a BATCH File which will automatically press

1). 'TAB' key.
2). 'Enter' key.
3). Copy some content from a TEXT file and PASTE over a 'Text Box'.

Thankx in Advance.Not possible in Batch. Possible in VBS.Are you sure we cannot press 'Tab'/'Enter' key. There must be some code.Negative.

Do you want the VBS code?
Ok . If you have the VBS code then please give me.

Thankx.Code: [SELECT]set WshShell = WScript.CreateObject("WScript.Shell")
WScript.Sleep 2000
For i = 1 to 1
WshShell.SendKeys "{TAB}"
WScript.Sleep 500
Next
Save it as file.vbsThank you for your reply it is working fine.
What is vbs code to open a web page.

Thank youI have got the answer for my question . No need for searching it.

Thank you.Heh, all right.

hey all,

I've written a script that I run and users machines once I've installed xp. It just installs the needed programs and saves me having to do it.

So far I've been using timed pop-up's to alert me when programs have finished installing. I'd really like to have a progress bar DISPLAYING the current program being installed and the progress of the script.

Is this possible in VBS??

Bearing in mind that the script attached is about my limit in VBS, can you point me in the right direction??

Thanking youNo elegant solutions that I'm aware of. It's possible to USE an HTML progress bar object within IE, but that usually raises all SORTS of pesky ActiveX issues. You can also wrap an HTML FRAMEWORK around your VBS code creating a HTA file. This eliminates the IE issues but you lose access to the WScript object and it's methods and properties.

Your code shells out to many external files, which would make UPDATING the progress bar problematical.

I need to write a bat SCRIPT which starts 3 services in a predefined order and if any of these services doesn't start PROPERLY then script should terminate WITHOUT TRYING to start services below it.

For Example: let there be 3 services ServiceA ServiceB, ServiceC.
First ServiceA should be started then ServiceB and then ServiceC.
If ServiceA doesnt start properly then script should terminate without starting ServiceB aand ServiceC. And also if ServiceB fails then it should not start ServiceB but also stop already started ServiceA.

Please help me in this.

Thanks in advance.

~Gaurav
[link removed - please don't ADVERTISE]
Something like this might work:

Code: [Select]@echo off
net start serviceA
if errorlevel 1 goto :eof
net start serviceB
if errorlevel 1 (
net stop serviceA
goto :eof
)
net start serviceC
if errorlevel 1 (
net stop serviceA
net stop serviceB
goto :eof
)

This might work with || and && but I didn't have any services lying around waiting to be started, so you'll have to do the testing.

One software or ANOTHER changed the FORM code I had to having no ID, and I'm getting an error - "Associate form controls with tags using the 'id' attribute."
How do I put the id and LABEL tags back in?


129 Search The Internet
131
133
134
135
136 http://www.actualcures.com/loggo.gif" alt="Google" />
137
137
137
138
138
139


Thanks,

Roscoe

anyone can tell me what kind of programming language, DATABASE suitable for the expert model for the intelligent tutoring system(ITS)?

Here is some info:
http://en.wikipedia.org/wiki/Intelligent_tutoring_system

And With GOOGLE being my source, I found out that ITS('s) are programmed with C++.

I think I answered your question, I'm not quite sure what you MEANT but hopefully this HELPS If you need some C++ or C# HELP or tutorials go ask on programminghelp.com they have a couple of SMART C guys over there. Good luck with your installer=)

we have a series of towers xp, sp2/sp3 that we back up every night to a server. i use the following code...

rasdial.exe (establishes VPN)
set folder=%date:~0,2% (every day it backs up, it makes a new folder for 31 DAYS and rewrites on the particular day)
net use.... \\server\...(maps drive to use, destination)
cd C:\Operations\Forms (source)
ECHO D| xcopy c: \\server\pll065\%folder% /s /E /h /D
rasdial.exe test /disconnect
shutdown -r

i have downloaded the sleep.exe file, and should that be in the system 32 folder, somewhere else, or does it really matter where it is located? what i would like is a series of pauses (after rasdial.exe and net use...) i know that i have to use sleep XX to stop the process for XX seconds, but location of sleep is what i need to know.

also, how can i get the above batch file to create a report INDICATING date, how long the vpn was establihsed or how long it took to run the batch and amount of files that were updated? something like yyyy-mm-dd, hh:mm:ss, X files updated or backedup?

thank you,

jat

System 32 is the correct place for Sleep.exe

And for the reporting document. try the following code.
Code: [Select]echo %date%, %time% VPN Established > Report.txtadd this right before the rasdial.exe

then

Code: [Select]echo %date%, %time% VPN Disconnected >> Report.txtadd this right before the shutdown -r command.

In Report.txt it should look like this.

, VPN Established
, VPN Disconnected

Quote from: macdad- on July 15, 2008, 05:10:41 PM

System 32 is the correct place for Sleep.exe

Hi

I've CREATED my own INVOICE in excel.
what I would like to do is have about 6 row so I can add items, when I fill in the 6th row it will AUTOMATICALLY insert an new row with the PREVIOUS formula.

If someone WANTS to mail me direct I have no problems then I can send a file and further explanations.

Thanks in anticipation

Regads
Pohhop

hi guys,

I'm writing some VBA code in outlook and I'm after a little help.

In access, I have a database called "CUSTOMERS" with one table within it called "New Customers" This table has 9 fields, first-name, last-name, home number, mobile number, appointment date, appointment time, CITY and DESCRIPTION.

In my outlook code I have 9 filled variables called, lanme, fname, homenum, mobile, apdate, aptime, city and descript. (which are pulled from a FTP site after a email comes in with a certain subject) I like to be able to fill the fields of my database with these variables from outlook.

This is even possible???

Can anyone point me in the right direction??Ok,

So i've created a connection in ODBC, and used the code below to CONNECT to it.

Code: [Select]Set objADOConn = CreateObject("ADODB.Connection")
objADOConn.Open "DSN=ocs"


As I understand it, I'm suposed to use a recordset and a SQL statement. Sad thing is, i have no ideas what either of these are/should be !!!This Scripting Guy article should show you a generalized method. Most of the code is boilerplate. You need to fill in the particulars.

Code: [Select]objConnection.Open "DSN=ocs"

objRecordSet.Open "SELECT * FROM Employees", _ 'name of table to update
objConnection, adOpenStatic, adLockOptimistic

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("C:\Scripts\Test.txt") 'name of FTP file

Code: [Select] objRecordSet.AddNew
objRecordSet("db lname") = ftp lname
objRecordSet("db fname") = ftp fname
objRecordSet("db home num") = ftp home num
objRecordSet.Update

The recordset methods do all the heavy lifting. If you have any questions be sure to post back.

Good luck. Fantastic!!!

I had to jiggle a few things round.

I already had a function to read values from txt files, so used that instead.

But it work's like a CHARM!!

Thaking you!!




Code: [Select]Private Sub update_access()

Fname = GetFileContent("C:\FTPfeed\fname.txt")
Lname = GetFileContent("C:\FTPfeed\lname.txt")
email = GetFileContent("C:\FTPfeed\email.txt")
homenum = GetFileContent("C:\FTPfeed\homenum.txt")
mobile = GetFileContent("C:\FTPfeed\mobile.txt")
APdate = GetFileContent("C:\FTPfeed\APdate.txt")
APtime = GetFileContent("C:\FTPfeed\APtime.txt")
city = GetFileContent("C:\FTPfeed\city.txt")
descript = GetFileContent("C:\FTPfeed\descript.txt")

Set objADOConn = CreateObject("ADODB.Connection")
objADOConn.Open "DSN=OCS"

Set objRecordSet = CreateObject("ADODB.recordset")

objRecordSet.Open "SELECT * FROM data ", objADOConn, adOpenStatic, adLockOptimistic

objRecordSet.AddNew
objRecordSet("LastName") = Lname
objRecordSet("FirstName") = Fname
objRecordSet("HomePhone") = homenum
objRecordSet("EmailAddress") = email
objRecordSet("Appointment Date") = APdate
objRecordSet("Appointment Time") = APtime
objRecordSet("City") = city
objRecordSet("Description") = descript
objRecordSet("MobilePhone") = mobile
objRecordSet.Update

End Sub

Hey,

I have an idea for a program, but I'm unsure as to how QBASIC would do this. I want to have:

Type to read from drive A... etc.

And then using the SHELL statement access the drive, redirect the contents to a file and then print the contents of the file to stdout in a format that I choose. Maybe in a box or GRID and aligned to the middle. So far I have the OUTPUT of DIR A: redirected to a .txt file but I don't know how to use the OPEN statement to get the file placed in the variable.

Anyone help?

I know QBASIC is vintage stuff, but it's fun to mess around with it and learn stuff . This belongs in the Programming forum.Which version of QBasic are you using?Yes. There's the QBasic ide / interpreter which comes with MS-DOS & Windows 95/98/ME, and there's QuickBasic (various versions).
I'm using the Qbasic IDE with MS-DOS 7.10. As you have the latest and greatest MS-Dos version I will assume you have QuickBasic ver 4.5.

At the top RH corner you will see "Help" which gives access to the QuickB help file. Access the Open command in the index and you will find a great screed about how files are opened.. I have attached two screen images from it to make things simple for you. The first image (Open) shows the latest way of opening a file in QuickB, the second (Open1) which I prefer to use when Access and Lock are not required, shows an older version which is included for backward COMPATIBILITY with QB.

The simplest command to open a sequential Input file (see Open1) is IMHO:
OPEN "I", #1, "Path\Filename"

Good luck



[recovering DISK space -- attachment deleted by admin]QuickBasic 4.5 is the last version of the commercial Microsoft BASIC ide & compiler which can make .exe files. Qbasic is the cut down product provided as part of MS-DOS and Windows 9x. It cannot make exe files. I think it is clear that CosmicFlux has the latter.Quote from: Dias de verano on July 28, 2008, 10:28:35 AM

QuickBasic 4.5 is the last version of the commercial Microsoft BASIC ide & compiler which can make .exe files. Qbasic is the cut down product provided as part of MS-DOS and Windows 9x. It cannot make exe files. I think it is clear that CosmicFlux has the latter.

Oh, the IDE says MS-DOS QBasic version 1.1. Should I get 4.5?

Ok i read in the index that QBASIC PDS 7.1 can work with .OBJ files. and some 3D files are OBJ Files. Does that mean that QBASIC can work with 3D graphics(like the ones in Doom). I know this is probably a stupid question but i have never worked with QBASIC.

Thanks in Advance.
Well now, possibly

Good luckThanks Dusty.I'm not particularly sure what your asking, but any programming language capable of graphics (QB and all it's flavours, for example), is capable of 3d graphics, it's just that you'll need to write the 3d-transformation and projection code, not EXACTLY a light undertaking. I'm sure you'll find libraries of some sort that can help you.


the QuickBasic Index is talking about Object Code files, which are generated one per each module, and then linked into the final EXE. this is true for almost all compiled programming languages. For example, if you had a Module called "MODMAIN.BAS" and another called "MODPROCS.BAS", you could write a bunch of helper procedures in MODPROCS, and, given the appropriate include information (in a .BI file, if memory serves) you could use procedures in MODPROCS.BAS (compiled to MODPROCS.OBJ by the BC compiler) in MODMAIN.BAS! Then, MODMAIN.BAS would be compiled to an OBJ file as well, and both it and MODPROCS (and I believe some runtime OBJ files as well) are linked into a final executable.A case of extension confusion I think.
The part I think is humourous is that the OBJ 3d file format is almost sure to have been invented LONG after Quick Basic 7.1 was released.well thats pretty much why i asked the question. cuz i knew that obj is a 3D file but since your telling me that it was created after QB came out then that changes the story. but thanks BC for your helpQuote from: macdad- on July 19, 2008, 06:42:02 AM

well thats pretty much why i asked the question. cuz i knew that obj is a 3D file but since your telling me that it was created after QB came out then that changes the story. but thanks BC for your help

Hi, I'm LOOKING for the the Dll crpe.dll pertaining to Crystal Reports 8.

Does anyone knows which Dll version use the CR8?

Cheers

There seem to be two of them crpe.dll and cpre32.dll. You can check this page and decide which is relevant. You can also DOWNLOAD the QUERY engine if that is helpful.

Good LUCK. thanks a LOT, I'll check it!!

I need to FINISH this program as soon as possible and i am having trouble. The specification is to Write a Java program NAMED lab32. The program gets the length and the width of a rectangle from the user, calculates the area and displays result. CREATE, compile and test the program using jGRASP compiler.


import javax.swing.*;
public class lab4
{ public static void main(String [] args)
{
doublearea;
double length;
double width;

//DECLARE three variables named length, width and area of type double
double length, _____width_____, _____length_______;
//Declare a String object
String s;
//Input the length using showInputDialog
s = JOptionPane.showInputDialog(“Enter the length:”);
//Convert the length input to double
length = Double.parseDouble(s);

//Input the width using showInputDialog
_________________________________

//Convert the width input to double
__________________________________

//Calculate the area
__________________________________

//DISPLAY the length, width and area
System.out.println("Length: " + length);
//Display the Width
____________________________
//Display the area
____________________________

System.exit(0);

}//close main

}//close the class

Sample output

I'm trying to create a batch file that will swap my SECONDARY monitor with my TV. Anyone have any helpful tips. This is my first attempt at batch files. I"m using the Catalyst Control Center.You mean like FN + F7?Not exactly. I've got a dual monitor setup at my desk. I also have the Svideo out going to my tv. I am trying to come up with a batch file I can run when I WANT to swap my secondary monitor with my tv. That way I can watch movies I have on my computer directly on my tv. CURRENTLY I have to bring up the Catalyst Control Center, LET it load, swap the monitors, change the RESOLUTION. I'm just trying to save time.

hey all,

I've got my self a website that has a sql database on it. The data base currently holds data from an online form.

I'd like to have a script that can download the last entry from the database but I'm unsure how to go about it.

The hosting company have provided me with a "perl" and "php" string so I can connect, but I've never used either language, so I'm a bit lost.


Anyone got any ideas??

Cheers in advance Have you got PHPMyAdmin on your website? There is an option to download the database in a .zip file.
But if thats not what you want, Im sure you could PHP Mail to email the last entry in the form to you.

Good luck. thanks for the reply.

yes, I do have PHPMyAdmin in my control panel but I'm trying to automate it and I couldn't find a setting to do this for me.

Basically, the site has been written by SOMEONE else, and I'm trying to add a few features. I no nothing about coding websites, so trying to get the site to email me with the data i need when in input's to the database, is like try to get blood out of a stone!!!

What's the easiest platform to run php code on my local machine??

I'll get that and then script a SQL query that will get me the information I'm after??

Cheers agian
ok, I've installed wamp and I can now run xxx.php script from the command LINE.

I'm using this;

Code: [Select]<?php
$dbhost='localhost';
$dbuser='root';
$dbpass='password';

$conn=mysql_connect($dbhost,$dbuser,$dbpass)ordie('Errorconnectingtomysql');

$dbname='petstore';
mysql_select_db($dbname);
?>

am i right in thinking that "dbhost" should be my website address?? (www.xyz.com) the dbuser and dbpass are PRETTY clear, as is the dbname.

I'm getting an error "Fatal error: Call to undefind function mysql_err() on line 6"

any ideas?Quote from: blastman on July 21, 2008, 09:34:27 AM

am i right in thinking that "dbhost" should be my website address?? (www.xyz.com) the dbuser and dbpass are pretty clear, as is the dbname.

Code: [Select]<?php
$dbhost='localhost';
$dbuser='root';
$dbpass='password';

$conn=mysql_connect($dbhost,$dbuser,$dbpass)ordie('Errorconnectingtomysql');

$dbname='petstore';
mysql_select_db($dbname);
?>

i want to make a circle consisting of 72 LEDs (in visual basic using ACTIVEX controls) can some one help me out how to make this i ll b very grateful and can someone guide me from where i can get free activex controls like TOGGLES switches,,,buttons,,LEDs,,,ETC any link or so plz
regards
honeyMany ActiveX controls are commercial products ($$$). If money is no object and you're REFERRING to VB6, this may just help you out:

ActiveX

Good luck.

Hi Guys,

I'm a new guy here, and looking forward for your assistance.

I developed an ms access database and WANT the USER to invoke it thru batch script, my problem is each users INSTALLED their ms access software in different location (not consistent), my intension is to locate that ms access exe and execute it. I have my initial script but the output giving me "\\" before the exe file name (i.e. C:\PATH\\MSACCESS.EXE).

Here's my code: This script is giving the result on the first occurance only (first find)

Code: [Select]@ECHO OFF

SET filename=msaccess.exe

FOR /R C:\ %%a IN (\) DO (
IF EXIST "%%a\%filename%" (

SET fullpath=%%a%filename%
GOTO break
)
)
:break

ECHO %fullpath%

pause>nul
Any Help will be appreciated.

Thanks Guys.A while back when dealing with Access97 and 2000, I just used this instruction which worked:

msaccess.exe "\\UNC Path to \database.mdb"


You place your shared database location into the UNC path. This way it doesnt matter where MS Access is installed, Windows knows where MS Access is and invoking this command with a UNC Path should work for you. The Batch File could be a single line, however you can do away with batch and just mail a shortcut that invokes MSACCESS.EXE "\\Database_Path_Location\Name.mdb"

As long as everyone is running same version of Access, installation location not important, you are all set, however if this database is for say 2003 and you have users with other versions you can run into version mismatches and run into issues which you are probably already aware of.One of the first things, is that you are calling msaccess.exe, not a specified db file.

Quote

SET filename=msaccess.exe

Env: MS Server 2008, MS SQL Server 2005

During the last couple of months I've discovered the beauty of outputting reports from MS SQL DB by calling sqlcmd from batch files.


This batch file outputs data that correspond to the WHERE clause, meaning that is 7 days old or newer.

Code: [Select]@ECHO on

setlocal enabledelayedexpansion


:: How many days back should a date
:: be calculated?

set days=7

:: Calculate date that is x days back
:: for use in SQL Query below.
:: Date format on server: YYYY-MM-DD (2013-02-06)
:: Date format for SQL Query: YYMMDD (130206)

echo wscript.echo ^(Date^(^)- %days%^)>day.vbs
for /f %%a in ('cscript //nologo day.vbs') do set ydate1=%%a
del day.vbs
set ydate1=%ydate1:/=%
set y=%ydate1:~0,4%
set m=%ydate1:~5,2%
set d=%ydate1:~8,2%
set ydate2=%y%%m%%d%
set ydate3=%ydate2:~2,7%

SET SQL="SET NOCOUNT ON;SELECT col1,col2,col3 FROM t1 JOIN t2 ON (t1.col4=t2.col2) WHERE (t2.col1 LIKE '%%Wildcard goes here%%') AND (t1.col5 >= '%ydate3%') ORDER BY col1 ASC"

call sqlcmd -S server\s1 -U sa -P pw -d DB -Q %SQL% -o output.txt -u -n -s "" -w180

endlocal

The problem:
Seems as wildcards inside the SET SQL won't work for me.
ANYONE who knows what I'm doing wrong here?

Any help is appreciated! http://www.w3schools.com/sql/sql_wildcards.asp
Are you trying to use DOS type wildcard ( * ) in place of what should be SQL wildcard instruction of
( % ) ?...and are you aware of the need to escape percent signs in batch scripts?
Good point Salmon Trout, you have to use ^% vs ^*Thanks for advice guys. I tried to escape the percent sign with ^% using the following combinations:

^%
^%%
^%^%

but can't get it to work. The query returns nothing and I'm SURE it isn't because of the %ydate3% clause which works fine when I only use that one.

Previously I followed Rob van der Woude's advice, which also don't fix it: In batch files, the percent sign may be "escaped" by using a double percent sign ( %% ).
That way, a single percent sign will be used as literal within the command line, instead of being furter INTERPRETED. (source: http://www.robvanderwoude.com/escapechars.php)
Quote from: DaveLembke on February 06, 2013, 04:11:43 PM

Good point Salmon Trout, you have to use ^% vs ^*

Do you get an output if you run the query manually? Have you checked that the batch is producing exactly the same query?

I need help writing a python script that will loop through a jar file and extract all files of a specified TYPE while keeping the file and directory names.

Using the latest version of python 3use the ZipFile module. You'll have to test the entries yourself. maybe something like this: (untested):

Code: [Select]#!/usr/bin/env python
import OS
import zipfile
zip = zipfile.ZipFile(argv[1], 'r')
for name in zip.namelist():
#perform test condition here to see if name is a name you want to extract.
#eg if name.endswith(".java"):
zip.extract('.\'+z.read(name))
zip.close()
how do i pass the jar path to the zipfile object?
When I pass a file path in quotes to ZipFile() It returns
MessageFile NameLinePosition
SyntaxError
(unicode error) 'unicodeescape' codec can't decode bytes in position 2-4: TRUNCATED \UXXXXXXXX escape (module1.py, line 16)C:\Users\Jordan.Office-PC\Desktop\module1.py1622

How can I fix this?
Python String literals


You are inadvertently using an escape character. (\U). As the documentation notes before the table:

Quote

Unless an "r" or "R" prefix is present, escape sequences in strings are interpreted according to rules similar to those used by Standard C.

I get the same error with 'r' in there.

could be that I am on windows vista and need to find a way to run a py script as admin?

P.S:your documentation is for 2.7.4, I am using 3.2.1

Hello, this is my first post.
I'd like to know if/how I can RUN a PYTHON script from a vb PROGRAM.
Please/thank you.

i am making php mysql code for admin side to delete ITEMS from shopping cart.Please FIND the error in the code , cause i cant find it.

Delete product is the place where i show the items selected by productid as options for admin to choose to delete.
Delete product works ,whose screen short can as well be shown in the document file.Delete product then submits the CHOSEN selected item to delete product1.

Delete product 1 is where i am trying to delete the option as chosen by admin via delete product.I tried my best to remove error in the delete product 1 but couldn't solve it , i will be grateful if you did.Please remove the errors in delete product document file.

1)Delete product code working showing form to choose option for deletion as shown in the image
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
http://www.w3.org/1999/xhtml">


Delete Product Details


function clearText(field)
{
if (field.defaultValue == field.value) field.value = '';
ELSE if (field.value == '') field.value = field.defaultValue;
}








include 'header.php';
?>







Delete Product Details



if(isset($_SESSION['uname']))
{
include 'dbconnect.php';
echo "Welcome ".$_SESSION['uname'].",";
?>
if($_SESSION['utype']=='A' )
{
?>

Product ID : $txtPName one quantity deleted";



}
catch(PDOException $e)
{
echo $e->getMessage();
}
}
else
header('location:deleteproduct.php');
}
else
header('location: adminlogin.php');
}
else
header('location: adminlogin.php');
?>

sir
please give me the complete detail of C++ BASICS which are helpful to me in writing any kind of program using c++. i mean i want the basics of c++?;;;;;;This is in plain English.
Quote

C++ All-In-One Desk Reference For Dummies by John Paul Mueller and Jeff Cogswell (AUG 31, 2009)

$2.26 Paperback (Used)
http://www.amazon.com/s/ref=nb_sb_ss_c_0_8?url=search-alias%3Dtextbooks-tradein&field-keywords=c%2B%2B+for+dummies&sprefix=C%2B%2B+for+%2Caps%2C269&rh=i%3Atextbooks-tradein%2Ck%3Ac%2B%2B+for+dummies

This is in plain English.

i am trying to create a letter generator in excel / word like this :
http://www.youtube.com/watch?v=-npLOc6UUbQ
i have an excel data base with customer infomation and a word document that i fill the info in, at the momeny manually , i wold like to create a button on the excel doc that automatically generates a word document, or even a PDF,


PLEASE HELP!ACCESS Database with VB would be better than a flat excel spreadsheet database. As far as making PDF's, this can be done by PASSING a print INSTRUCTION with default printer of doPDF which is free. As far as populating a MS Word document, I haven't done that yet automatically without other macro software, however the information can populate a FILE that is saved as a *.doc etc and formatting tailored to work in the VB file write.

*Unable to view the video you linked from work, but just suggesting what I would do if I had to have a database that generated PDF's and letters/documents.

Is there anyone who can change a javascript code to a HTML code or Flash code for me, or help in anyway.

What are you trying to achieve? Linking the code will show us what you have and are trying to do as well.

All 3 of those are way different than another. Its not like Visual Basic, Visual C++, and Visual C# which for the most PART can all be coded to PERFORM same tasks, some of which perform the task better ( more efficiently faster and less coding than the other ).

Javascript runs within HTML, and HTML alone is no different than looking at a word document with formatting for font size etc in plain view. Flash can run within a webpage or EXTERNAL to a browser with a flash player etc.

Javascript and Flash can be used to spice up the limitations of HTML. And if ANYTHING you might be able to convert a Javascript to a Flash program, but never either of them to HTML unless you are only displaying static text that never changes. Looking at your JS we will be able to ASSIST further.


This is the code, wordpress do not allow javascript

i=100
l=1
zulupass = input("please enter three digit passcode")
if zulupass=="666":
print("welcome")
open("/Users/johntoniolo/Documents/pythonprojects")
else:
print("retry")
zulupass = input("please enter 3 digit passcode")
l -=1

if l<=0:
while i>1:
print("ATTEMPTS EXCEDED!!!!!!")
i -=1




OK I WANT THIS PASSWORD PROJECT TO OPEN ANOTHER FILE UPON PROPER PASSCODE... SO HOW CAN I MAKE A PYTHON PROJECT OPEN A SPECIFIED DIRECTORY. (IM ON OS X BTW) as you can see in line 6 i want to open a file. what am i doing wrong or is python not capable of opening files. im very NEW this is my like 4th program WRITEN.

thanks
iUserQuote

open("/Users/johntoniolo/Documents/pythonprojects")