Skip to content

Tag: variables

PLSQL – Use variable array on where clause IN

I am looking to use an array of values in the WHERE IN condition. After research, I saw that I had to make a “CREATE TYPE”, since a “TYPE” in local does not work. This solution does not suit me, I do not want to make a new TYPE in Oracle, since the database is used for an ERP/PGI I

Using Variables in a MSAccess Function with SQL

I’m struggling with entering a custom made ID number on all my tables to link all records together, trying out normalization. I have an EmployeeDetails table and a LoginDetails table. Its my understanding that I need a field called EmployeeID on both and I can use the SQL Select code I have to pull the data like on other forms.

Adding Variables to SQL queries

I have the following code which returns a table from my ms sql Database How would I add the one_yrs_ago variable to the SQL query in this situation , like so : Answer Not seeing the full context but this is how I would do it in SQL Server I would say parameterize what you pass in is important as

How to access multiple variables outside foreach loop in php

I am not a php pro and have already explored different online search forums but could not find any suitable answer and that’s why posting my question here. Function One: Runs a query to database and define variables in foreach loop as follows: Function two: Now I want to get the values of those variables in another function as follows:

Update row if exists or insert

I’m working on a web based PHP form that’s currently connect to an Oracle database. I’m trying to get the functionality working so that after a user submits the form it’ll check if a row exists based on the Job Number, if it does then update, otherwise insert the values. It’s bring back an internal server error at the moment