|
Standard question #1:
What do you mean by "not working"?
In SQL, use the value 0 or 1 for boolean values. True should also work in Access, as it is a constant defined to the value 1. Try this, anyway:
SELECT *
FROM ProductCat
WHERE ProductActive = 1
ORDER BY Part_Number
---
b { font-weight: normal; }
|
|
|
|
|
The SQL will list some products only if the checkbox is checked in AccessDB. If it's not, the product will not be listed.
In fact, my true SQL Statement is:
SELECT *
FROM ProductCat
WHERE Keywords LIKE '%MMColParam%' or Part_Category LIKE '%MMColParam%' or Part_Name LIKE '%MMColParam%' and ProductActive = 1
ORDER BY Part_Number
..and I remember something like using brackets because of the multiple "or" and "and"....It's been so long!
To answer your question #1, not working means the product that's not supposed to be listed, is listed...
|
|
|
|
|
Nice... How do you think that someone could find the error in your query when you show some other query... 
The and operator har higher precedence than the or operator, so you have to do like this:
SELECT *<br />
FROM ProductCat<br />
WHERE (Keywords LIKE '%MMColParam%' or Part_Category LIKE '%MMColParam%' or Part_Name LIKE '%MMColParam%') and ProductActive = 1<br />
ORDER BY Part_Number
---
b { font-weight: normal; }
|
|
|
|
|
|
I am working on a project that is like a small course. You read the first couple of slides and then answer Multiple choice questions at the end. The project can be done in multiple ways. I am trying to do this in 2 webforms!!! 1 for all the slides and the second one for the questions.
The thing is - the title and the Back & Next buttons stay consistent in every slide. The only thing that changes is the main content (slide info). Is there a way to load THAT content dynamically, ie, after clicking back or next. Instead of creating webforms for each page.
I was wondering if I could use HTML or XML to read the slide contents from a file and then display them keeping the title and back/next link buttons consistent. Any help in this matter would be appreciated. Thanks!
SMH
|
|
|
|
|
Do not double post.
If you really think that you need the question in both categories, just post a reference to the original post in this category.
---
b { font-weight: normal; }
|
|
|
|
|
Create two controls for the two views that differ, then only ever have one visible.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hi All,
i am trying to find a free component that will allow me to upload multiple files (without having 50 htmlInput controls on the page) from my client to the server. I've been googling for hours on this now but the only ones i find either costs a lot or are just no good. does anybody know of a good component that could do this for me??
Thanks.
|
|
|
|
|
|
go to the site planetsourcecode.com, there u will find lots of components for free.
|
|
|
|
|
 hello
i have this error only on your server , and i can do it well in any others server , help me , thank you !
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
/hamayesh84/image/image.asp, line 53
800401f3
------------------------------------------------------------------------------------------------
And in line 53 i have this code :
set tools=server.createobject("mswc.tools")
Nice to hear any guide from you !!!
|
|
|
|
|
Looks like the object that has that name is not registered as a COM object on your server.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
i have this problem on my host , and i search on net , and microsoft told me to download "IIS Resource Kit components" package to solve it , but it doesnt solve my problem , so explain more to how do this ??
And i use this code on my IIS at my own computer , and there is not such a case , THANKS !!!
Have good day and time
|
|
|
|
|
delnaz wrote:
And i use this code on my IIS at my own computer , and there is not such a case
The error means your code expects a COM object that is not registered on the server. It's obviously registered on your machine. If you know the path to the exe in question, go to that directory in the console and type regsvr32 yourfile.dll and you'll get a message to say if it could be registered.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
|
help me...
I have some troubles with M.Access. I want to create the calendar control on a form of my Access database like the calendar control of vb.net or C#. However, I can't find the way to do that .Thus, I'm very happy if you help me...<vtalau>
|
|
|
|
|
office 2003:
in the toolbox :
click the (more contros button)
from the menu Select Microsoft datetime picker
draw the control on the form.
|
|
|
|
|
Occasionally when I click on a link in an Outlook Express mail and IE launches, IE hangs.
If I kill IE and repeat the operation it works OK. I think this only happened after moving to SP2. I have all patches applied (except for yesterday's).
Any ideas?
Kevin
|
|
|
|
|
Hi,
I want to implement google suggest technology(listing down the relevant names as and when the user types) in my J2ee application.
I know that we can implement this using simple Javascript.
But google suggest technolgy uses AJAX for this.
Which one will be the best solution to implement .Is it using Javascript or AJAX?
AJAX is very complicated to implement.
Pls suggest
Thanks
Ram
|
|
|
|
|
hi
i m new to the field of activex and i want to know that are activeX (internet activex) made in the vc or vb are capable of self registering. or had to something extra to
register them. particularly the (internet activex) controll. if not that what functions will be used to register them.
i had made the (internet activex) that play the movie on the page i want to know that when user will visit my page then ocx will be selfdownloaded
and selfrejisted to that client pc. or what will happen.
ddd
|
|
|
|
|
bOTH vb or vc's activeX r capable of self registering. U just need to create the cab version of your activeX (OCX) ... i think u should know the cab version... for exceptional cases i m informing you that..whenever you create the setup of any project, that setup creater also has options like u want setup or cab version... so create the cab version of your ocx. cab versions automatically downloaded to the visitor and then registered automatically..oh yes u also need to write tag of the cab of ocx version inwhich page u need that control.
regards,
|
|
|
|
|
bOTH vb or vc's activeX r capable of self registering. U just need to create the cab version of your activeX (OCX) ... i think u should know the cab version... for exceptional cases i m informing you that..whenever you create the setup of any project, that setup creater also has options like u want setup or cab version... so create the cab version of your ocx. cab versions automatically downloaded to the visitor and then registered automatically..oh yes u also need to write tag of the cab of ocx version inwhich page u need that control.
regards,
|
|
|
|
|
I'm trying to trim dynamic text into my ASP/Javascript using the Left Function, but without any success. Here's my form:
<%
var RecordCounter = 0;
%>
<%
var RepeatCounter = -1;
%>
<% while ((Repeat1__numRows-- != 0) && (!rsPriceMod.EOF)) { %>
>
<% RepeatCounter++;
Response.Write(RepeatCounter + 1)%>. <%=(rsPriceMod.Fields.Item("Part_Number").Value)%><%=(rsPriceMod.Fields.Item("Part_Name").Value)%>
<%=Left(rsPriceMod.Fields.Item("Part_Description1").Value,5,)%> <%Repeat1__index++;
rsPriceMod.MoveNext();
}
%>
The following error message occurs:
Microsoft JScript runtime error '800a138f'
Object expected
/DescriptionMod.asp, line 451
...where line 451 has the left function!
|
|
|
|
|
There is no Left function in JScript. Use the substr or substring method of the String object.
---
b { font-weight: normal; }
|
|
|
|
|
this is what I have in my page:
<% Response.Write((rsPriceMod.Fields.Item("Part_Description1").Value)) %>
Where do I include "substring"?
Thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
