say i have a field that lists car year, car manufacturer, and car model.....is it possible to parse this into 3 different outputs? considering they will be different lengths?
here is my code so far:
select
f.matteridstring,
f.custom1,
l.itemtext
from contacts c, parties p, fileinfo f, listbox l
where
l.itemtext like 'Lemon Law%' and
c.contactid = p.contactid and
f.fileno = p.fileno and
f.filetype = l.id
when i run the query i get 3 columns....in the last column i...
i need some major help here please. i need to create a mortgage calculator in excel when the user inputs the value of the mortgage, annual rate, loan duration, balloon payment, and number of pay periods a year. then i need to calculate the total payment of the mortgage. any ideas here?????? be...
im trying to help fix my friends computer, but i dont even know where to start. All she tells me is that the computer is shutting down randomly. So she starts it back up, and it will run normally, but then it will shut back off in 5 minutes or so. Any suggestions?
does anyone know why microsoft came out with .net 3.0.....what does it even do exactly? i was wondering becuase it recently was released along with some new ajax features i saw on the web whil browsing.
im having problems with my IE 7. we run google desktop no problem however though. IE 7 was uninstalled, then reinstalled, but no go...we had to put IE6 back on the computer. any ideas here?
need some help with coding...i want to be able to search my table first off...i want to be able to update the table, ONLY if the record IS NOT ALREADY THERE. i dont know if a CASE command will work here or not....please help.
This is what I have, but it doesn’t quite work.
INSERT INTO...
need some help with coding...i want to be able to search my table first off...i want to be able to update the table, ONLY if the record IS NOT ALREADY THERE. i dont know if a CASE command will work here or not....please help.
can anyone give me a good source of information for odbc and IIS together...also is there any other tpyes of data sources that can be used other than sql with odbc?
i have code here that i think is real close, i just need some suggestions on coming up with the final piece here. i want to run a batch file on my server using asp. the server is all up to date and windows scripting service says its ok, but im still not sure what the problem is.
url = Right(path, Len(path) - Len(rootPath))
can anyone tell me what the purpose of this line is, i cant figure it out. i need to cut down a file path name.
im using a sumif formula, but how do i allow myself to have 2 sets of criteria in the formula......this is what i need my formula to do, but i get an error:
=SUMIF(SiteY!B2:B108,"30-35""26-30",SiteY!D2:D108)
in my spreadsheet i have an agegroup column and the choices in there are 26-30...
is i possible to have a commande that allows me to search for a list of items in a folder. i need a listing of all subsequent folders and dont know if this is possible at all.
Im looking to create some code in VB that i need to take a file from a main folder and have it automatically copy this file into all subsequent folders. any ideas?
a simple little program for this would be great.
I was wondering if anyone knows the exact reason why in outlook a check is run on the inbox everytime it is started up. is it because in some cases the program is being run in cache mode? also how do i turn the check off everytime i start outlook?
all i want to be able to do is automate the process of inserting brand new rows into my table. when the table is scanned, i need to know when a record is NOT in the table so it can then be inserted. if a record already exists, then that item is skipped....any ideas for coding?
does anyone out there know how to code sql into bringing out a value from a list that DOESNT exist in the table. It sounds simple to do with a "doesnt equal to" but this isnt the answer i am looking for.
for example, you run the query and if itmes exist, then they are updated, if an item...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.