Good day, I don't have any Idea of what I am doing. I have asp.net and sql server installed in my computer. Now I have installed apache because I want to learn the basic on how to make PHP codes. I have alread download the file. Installed in my computer but this error came out:
(OS 10048)Only...
hi gud am,
im creating a report using VB, I have a parameter.
sample:
parameter = inputbox ("ENTER LASTNAME.")
SQLparam = "SELECT lastname, firstname FROM table1 WHERE lastname LIKE '*"" & parameter & "*'"
ive tried this but there's an error ples help...
Im making a program, the program suppose to produce a monthly report using data report in VB, but its not producing any thing.
ive added data environment and command1 as instructed by my boss. and put an sql statement in the command1 -> general tab. I have a criteria MONTH and YEAR for input...
what will i do if i want to have an input in vb using combo-box. And report generate thru CR. i have already code but it does not work. year always appear 1905.
startdate, enddate declared as STRING
startdate = combo1(0).Text
enddate = combo1(1).Text
startdate = Format(startdate...
select a_lastname, a_firstname, subject
from master
where subject = & "'*" & keyword & "*'"
this code in sql view in access still dosent work. what do you think is wrong with this code/statement.
it produce an error msg:
syntax error (operand missing) in query expression...
i have a very simple problem, but since im new to this i dont know what to put in my sql code..
i have a table called [masterlist]
biddate itbnumber ac
02/02/2001 ITB2-011-04 ov-10
08/28/2001 ITB2-011-04 uh-1h
12/10/2001 ITB2-039-06 f-27
01/10/2002 ITB2-039-06 uh-1h...
i have 2 queries from asscess.
the [ac/bid count] query that have the following feild
- aircraft type
- amount of bid price
- count of itb number
- percentage of bid price
with this query, everything works fine but every time i add the table
[summary date] query
- start date
- end date...
i have this sql code
select a_lastname, a_firstname, subject
from master
where subject = %keyword%
it dosent work, i think the problem is in the WHERE clause.
what is the correct way to right the WHERE clause to search for any word in any field of the SUBJECT field.. thanks
I have this database, where i have a field called BIDdate that has format "mm/dd/yyyy". i have a record of 100 of dates.
How can i get the first date record and the last date record, using SQL and with out any input of date range.
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.