Expression Is Typed Incorrectly

I am trying to run the following agregate function in a parameterized query on Access2000:

Min([t1].[f1]*sqr([t2].[f1]/[t1].[f1])/[param])

The query saved OK, but an attempt to run it results in the message:

The expression is typed incorrectly or it is too complex to be evaluated

If the sintax correct? Perhaps it is, otherwise it would not save. What can be done about it?

View Replies


ADVERTISEMENT

Page Refreshing Incorrectly

I have an asp page that gets populated from a SQL Server database. Normally
when the page gets displayed it displays the current record from a select
statement that can return lets say seven records.

The problem I am having is when I click the refresh button in IE, the page
displays another record instead of the record it was displaying before I
clicked on the refresh button.

I cannot figure out why it is doing this. Has anyone experienced a similar
problem? If so, what solution did you come up with.

View Replies View Related

Url Typed

I have a application that runs an asp page launched by an onunload event of
a page. If the user types a URL into the address line of the browser, i need
to be able to redirect him to that page once i've finished with my onunload
script. Is there a variable/property that lets me get hold of that typed
UTL?

View Replies View Related

Display The Text As It Has Been Typed...

My problem is that when I´m typing a text data in to the form and I press Enter to go
to a new line in PHPMyAdmin the field looks like this:

line1: text
line2: text2
etc.

But in ASP it looks like this:
line1: text1 text2

View Replies View Related

Counter To Track # Chars. Typed

I'd like to have a counter that tracks # of chars typed... so I don't risk having my message box truncated. Gonna be JS-based huh?

View Replies View Related

What URL Was "TYPED" In The Browser?

I am trying to figure out how to find the URL a browser is requesting if the user did not follow a link but typed the URL into their browser (or linked from an email message.) Similar to using HTTP_REFERER; except that header is blank if they did not click a link.

The object is to forward/redirect any request for pages at one domain to a totally different domain but maintain the complete path requested. It would be a non-issue if I had access to the DNS servers, but alas, I do not.

I am mainly an ASP coder and am only just beginning to look at ASP.NET, which I believe may hold the answer because there doesn't seem to be one using ASP.

View Replies View Related

SQL Expression

I am getting Syntax error saying Missing operator in query expression.

sql= "SELECT qryReferral_report.Employee, Sum(qryReferral_report.Amount) AS SumOfAmount, Count(qryReferral_report.ID) AS CountOfID"
sql= sql & " FROM qryReferral_report"
sql= sql & " WHERE (((qryReferral_report.CDate) Between #" & Date1 & "# And #" & Date2 & "#) AND ((qryReferral_report.StatusID)='C'))"
sql= sql & " GROUP BY qryReferral_report.Employee"
sql= sql & " Count(qryReferral_report.ID) DESC;"

I'm not real good at SQL, so I don't know what I'm missing. I think it has to do with the Sum and Count statments.

View Replies View Related

Regular Expression

Can anyone give me a regular expression for finding a URL in a string of
text?

Essentially what I want to do is find URLs in a text string and embed
them in {a href...} tags. However, I haven't used regular expressions
all that much in ASP/VBSCRIPT.

View Replies View Related

Regular Expression

I need to create a regular expression for a date field that works only
in the following format MM/DD/YYYY with the / in the format. No other
format can be inputted into the field. I need 2 numbers for MM 2
Numbers for DD and 4 numbers for YYYY. If the users enter 1 number for
month, 1 for day he should get an alert.

I have this code and thought it was working but it is not.

var RegExPattern = /(d{1,2})W(d{1,2})W(d{4})/;

View Replies View Related

Mismatch In Expression

I cant figure out why I get the following error...

Microsoft JET Database Engine error '80004005'
Type mismatch in expression.
/html/results.asp, line 60

rsSearchResult.CursorType = 0
rsSearchResult.CursorLocation = 2
rsSearchResult.LockType = 1
rsSearchResult.Open()
rsSearchResult_numRows = 0

View Replies View Related

Vb Expression Problem

I am trying to validate an input field that should only accept numeric values no larger than 6 digits to the left of the decimal and up to 2 digits to the right of the decimal. The values to the right of the decimal are optional though.

so the max format should be (xxxxxx.xx)

I tried this format:

"^(d{1,6}.*d{0,2})$"

but this format takes values larger than what i want.

View Replies View Related

Regular Expression

i know there are tutorials for Regular Expressions too, but can a 'simple' example be posted in these forms

View Replies View Related

Regular Expression

I'm going down the road of learing the pattern matching in regular
expressions, and I'm trying to convert the characters into English in my
head so I can see whats happening...

For clarity with this one...

[b]([^]]+)[/b]

Ok - the first thing I did was break it up - because it looks a nightmare
like that...so now I have..3 parts..

[b]

([^]]+)

[/b]

In part 1 I under stand that the is telling the expression that a special
character is coming next, thus escaping the [ and ] respectively, thus ,
and in part 3 I understand the same and also the escaping of the /, thus
- no problems so far...

In part 2 I'm assuming that the brackets are seperating a "pattern" so that
I might reference it as $1 later on, I understand that the [^] are saying
"not enclosed" so therefore it's going to ignore a ], the + sign however
perplexes me - my VBScript book says "Matches the preceeding character one
or more times" - so does that mean the ] just before it, or does it mean the
character OR characters defined within the [ ] etc?

View Replies View Related

ASP Query Expression

is it possible to have a replace() function in an SQL query? I need to use
something like that to be able to sort my "sequential-numbers", which are
actually textfields like this:

98.1
98.10
98.2
98.3
98.4

What I want is to query these numbers, convert them by removing the dot with
the replace command and the sort the recordset on it.

Is this possible?

View Replies View Related

Regular Expression Example

looking for a regular expression example for asp in vbscript. just want to search for a name in some text, possibly display that text.

View Replies View Related

Regular Expression

I'm trying to find a regular expression function to strip contents out of a string which lie between square brackets [].I've got one for chevrons (to remove HTML - as below), but would prefer not to have to replace the chevrons for square brackets first.Code:

function funRemoveHTML( strText )
Dim RegEx
Set RegEx = New RegExp

RegEx.Pattern = "<[^>]*>"
RegEx.Global = True

funRemoveHTML = RegEx.Replace(strText, "")
end function
how I can modify this for square brackets as opposed to chevrons?

View Replies View Related

Regular Expression For URL

I am working on an ASP page which looks in a set of text for web page URLs.

Using the VBScript.RegExp regular expression object, I have this regular
expression:

[a-z]+.[a-z]+.[a-z]+/

And it works well finding URL's such as: windowsupdate.microsoft.com,
www.cnn.com, etc.

However, I have been trying to modify it to ALSO find URL's like this:

www.amazon.com/index/sell/ie6.html?val=1
Or
www.microsoft.com/windowsxp

Any ideas?

View Replies View Related

Evaluation Expression

A client wants have acess to an online databases records controlled by group strings and evaluation strings e.g., each use would have in his client record a group string like this:

[ROOT][ADMIN][ACCOUNTING][ABC PRODUCTS]

And each record in a database would have an evaluation string like this :

([ROOT] OR [ADMIN] OR [ACCOUNTING] OR [FINANCE]) AND [ABC PRODUCTS] OR
[ACME]) etc.

No limit to the number of groups or the complexity of the boolean expression evaluation algorithm. I need an asp function that I will just pass the group string and the evaluation string and it will return True or False as to whether the client can view that particular record. I can't find anything in ASP on the internet though this must be a common database control method for non-browser applications? Has anyone done anything like this in ASP?

View Replies View Related

Regular Expression

I'm making url's out of text starting with "www" etc. but I've got two problems. Firstly, if the string begins with www it doesn't get matched, and secondly, if there's a dot or a comma directly after the url, it becomes part of the url. I hope someone who is better at this than me will be able to help me out. Code:

reg.Pattern = "(s)(www)(S)(S+)"
s = reg.Replace(s, "$1<a href=""http://$2$3$4"" target=""_blank"">$2$3$4</a>")

View Replies View Related

Expression Not Supported

I have a SQL statement here that im trying to troubleshoot, it is coming up with 'join expression not supported'. I have tried the statement in the access database (in msaccess) and it works fine without any errors. The statement is as follows:

Code:

strSQL = "SELECT 'tbl Item.Art_No', 'tbl Item.Description', 'tbl Item.BA', 'tbl Item.Retail Sales Price Incl GST', 'tbl Item Bin SOH.Location', 'tbl Item Bin SOH.Blocked', 'tbl Item Bin SOH.Stock on Hand' FROM 'tbl Item' INNER JOIN 'tbl Item Bin SOH' ON 'tbl Item.Art_No' = 'tbl Item Bin SOH.Art_No'"

View Replies View Related

Understanding Regular Expression

I have been using a regular expression that I don’t uite understand to
filter the valid email address. My regular expression is as follows:

<asp:RegularExpressionValidator id="valValidEmail"
runat="server"
ControlToValidate="txtEmail"

ValidationExpression="^([_a-z0-9-]+)(.[_a-z0-9-]+)*@([a-z0-9-]+)(.[a-z0-9-]+)*(.[a-z]{2,4})$"
ErrorMessage="Invalid Email address."
Display="None">
</asp:RegularExpressionValidator>

Can someone explain me why the email address Join Bytes! is
considered an invalid email address?

Also can someone explain me what the above regular expression means?

View Replies View Related

Regular Expression Syntax..

I need to parse the following:

aaa_bbb_d_yyyy_mm.ext

aaa = ITM, CPF, FAC, GEN
bbb = almost anything (even more then 3 chars)
d = M,Q,Y,R
yyyy = year
mm = month

I'm terrible at figuring out regexp so I turn to the kind folk of SP

View Replies View Related

Regular Expression Problems

I have a field that should take a date in the following two formats:

MM/DD/YYYY or MM/DD (and assume it is this year, it will fill in current year)

I have my program checking against two regular expressions. The first one is ok:

Dim regEx
Set regEx = New RegEx

regEx.Pattern = "^(([1-9])|10|11|12)/(([1-9])|((1|2)[0-9])|30|31)/200[0-9]"

If the date checked comes up False, it then goes to this expression:

regEx.Pattern = "^((0[1-9])|(10|11|12))/((0[1-9])|((1|2)[0-9])|30|31)"

My problem is on the second one. If I enter an erroneous date like this: 11/189

It will go through and crash my program.

View Replies View Related

Problem With Regular Expression

I am using regular expression to replace the text, This is asp function I have used to replace the text, but it’s not working properly Code:

View Replies View Related

Mismatch In Criteria Expression

I am trying to make my update page work, but when i submit the form it comes with this error "mismatch in criteria expression" and the problem i think lies on one of my menu list that is joined to another table in the database.

View Replies View Related

Regular Expression :: Replace

addContent = replace(addContent,"<font>","")

Right, pretty simple eh!

However, what I need is something to say replace all occurence of strings that start with "<font" to eb replaced by zilch i.e.

<font>
<font color=green>
<font tag=this another=more>

I believe regular expression are the way to go?

View Replies View Related

Regular Expression :: AlphaNumeric Only

any one have a quick regex for making sure that only 0..9 a..f are in a string?

View Replies View Related

Regular Expression :: Object

I'm trying to return a sub string using the regular expression object. I've not really used the regular expression object before and I'm finding it a bit clunky to use.

Basically I'm trying to match the 'description' within the string 'file_description_1'

However I'm unsure how to return the partial, would I use the Execute or Replace methods?

Regex looks like this:

With RegularExpressionObject
.Pattern = "file_(.*?)_[0-9]"
.IgnoreCase = False
.Global = True
End With

View Replies View Related

Search Using EXACT EXPRESSION

i m doing a custom search. i have included SEARCH USING:

1. ALL OF THE WORDS
2. ANY OF THE WORDS
3. EXACT EXPRESSIONS

i m not able to have the search results using option no. 3 EXACT EXPRESSIONS. how to do that thing ?

View Replies View Related

VBScript Regular Expression Object

I've discovered an insidious bug with the VBScript Regular Expression
object.I set the pattern to consist of the set of invalid filename
characters plus comma. I set global property to true then do a replace on a
SID. The Replace does nothing. However, if I attach the C++ (dev studio
2003) debugger to the IIS host process (dllhost.exe), every time I call
RegExp.Replace, the stack for one of the process's threads gets scrambled.
It ends up with the value 0x00000001 at the top of the stack! If your
debugger is set to stop on access violations, it always catches one (invalid
read trying to delete). The problem is insidious because, without the
debugger running, you would never know this is happening. ASP returns no
error. Potentially this could wreak havoc on your web application and cause
bizarre failures later on. Has anyone else run into this one? It seems to
happen only with the Replace method.

View Replies View Related

Regular Expression In Scripting Engine 5.1

I need a regex pattern that will grab a select or textarea tag in an HTML file. If I run
the pattern I should get:

<select name="whatever">
<option value="a" selected>A</option>
<option value="b">B</option>
<option value="c">C</option>
</select>

Or

<textarea name="whatever">Here is some text area text</textarea>

I know the following pattern works:

<(select|textarea).*(.|
)*?</(select|textarea)>

But the problem is my web hosting company is using ASP scripting engine 5.1 which does not support the non greedy delimiter (?). I doubt they are going to upgrade to 5.5 anytime soon.

I'll appreciate it if anyone can give me a pattern that does the same job but does not use the ? delimiter. Is there a way I can tweak the pattern above so that it works in ASP scripting engine 5.1?

View Replies View Related

Missing Opererator In Query Expression

i keep getting this error in this script on this line in display-course.asp

sql= "Select * from course_data WHERE Course_Id="&course_id &" ORDER BY Course_Date_From"

course.asp

Code:

View Replies View Related

Regular Expression :: Pick Out SQL Statement

I'm trying to work out a reg.exp. that will pick out a sql statement against a certain set of tables - in this case any table named "Survey~something~", but I only want to pull back those statements where the CompanyID column doesn't appear in the query. (The expression is being used in my editor so it might appear a little strange, but by and large it works the same as you'd expect.)

[^']select(.){0,100}from(.){0,100}Survey(.){0,25}where (.){0,200}

What do I need to add so that I get those without a companyid column?
Something like...

[^']select(.){0,100}from(.){0,100}Survey(.){0,25}where (.){0,200}(^companyid)

(tried this one, but it doesn't work)

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved